SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =329
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-04-28 14:29:54')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
61271 Zephyren 2022 NEW YEAR BAG
57102 Zephyren 2021 NEW YEAR BAG
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
56066 Subciety 2021 福袋 -NEW YEAR BAG-
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
4406 Nine Microphones LEATHER BELT -Punk Skater-WH/BK
4407 NineMicrophones LEATHER BELT -Punk Skater-BK/WH
4755 Subciety LEATHER BELT -CRAFT LOGO- BLK/GOLD
16245 Subciety LEATHER BELT-CRAFT LOGO- BLACK/WHITE
16246 Subciety LEATHER BELT-CRAFT LOGO- BLACK/GOLD
16247 Subciety LEATHER BELT-CRAFT LOGO- BROWN
52417 Zephyren 2020 NEW YEAR BAG
43842 Artemis Classic ACBT0010 4ピース唐草ベルト
10660 MISHKA (ミシカ) ETD CRACKLED DEBOSSED BELT BLACK
34774 Subciety (サブサエティ) MEDICAL BELT BLACK
34775 Subciety (サブサエティ) MEDICAL BELT WHITE
4826 LOWLIFE Wallace - Riveted Belt Slate Grey
4827 LOWLIFE Wallace Riveted Belt BLACK
13254 LOWLIFE Wallace The Blk Blue Rivets
61349 SLEEPING TABLET BANDAGE [ W RING BELT ] BLUE
31785 REBEL8 STANDARD ISSUE BELT
50388 SILLENT FROM ME KNOWN CRYPTIC -Ring Belt- BLACK
50389 SILLENT FROM ME KNOWN CRYPTIC -Ring Belt- WHITE
37903 NineMicrophones NYLON WEB BELT BLACK
45694 Subciety (サブサエティ) MAGNET G.I BELT BLACK
45695 Subciety (サブサエティ) MAGNET G.I BELT ORANGE
45696 Subciety (サブサエティ) MAGNET G.I BELT YELLOW
10344 LOWLIFE IRON MAIDEN BOTB STUD REVERSIBLE Belt
10347 LOWLIFE Black Red Swyd Perf Belt
13249 LOWLIFE SHRINK PYRAMID STUDDED BELT - GUN/RED
13251 LOWLIFE Devoid Studded Belt - Black/Blue
19119 LOWLIFE MOTORHEAD WARPIG
41689 ANIMALIA AN18U-AC07 SASH BELT NAVY
41690 ANIMALIA AN18U-AC07 SASH BELT OLIVE
42421 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT BLACK
42422 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT WHITE
42423 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT ORANGE
43978 SLIGHTLY NUMB VERTICAL CANVAS BELT CAMO
19740 Zephyren LETHER BELT-CRAFT LOGO - WHITE
19741 Zephyren LETHER BELT-CRAFT LOGO - BLACK
23234 Subciety ALOHA BELT NAVY
31690 Zephyren LETHER BELT-CRAFT LOGO - BLACK×WHITE
35962 Zephyren (ゼファレン) PAISLEY LETHER BELT WHITE
35963 Zephyren (ゼファレン) PAISLEY LETHER BELT BLACK
39021 DISTURBIA CLOTHING Ring Pentagram Belt
52899 SILLENT FROM ME 沈黙 -G.I Web Belt-
4828 LOWLIFE Triples Studded Belt Black/White
10345 LOWLIFE IRON MAIDEN Live After Death Belt
10346 LOWLIFE JACK PHOTO PRINT Belt
10572 LOWLIFE FALLEN STAR STUD Belt BLACK/PINK
10573 LOWLIFE FALLEN STAR STUD Belt BLACK/YELLOW
10583 LOWLIFE COVER UP SLIM Belt BLACK
13255 LOWLIFE Clyde Textured Black
13258 LOWLIFE Triple S Studded Belt Royal Blue/Blue
15521 ICECREAM GI BELT GREEN
15526 ICECREAM GI BELT BLUE
19109 LOWLIFE DUB Neon green yellow
19113 LOWLIFE ADDER Leopard
19115 LOWLIFE TRIPLE S Neon Yellow
19116 LOWLIFE TRIPLE S Neon Green
19120 LOWLIFE SINGLE STUD Black Silver
19121 LOWLIFE SINGLE STUD Neon Pink
19125 LOWLIFE CLYDE Brown
41156 ANIMALIA ANAN18S-AC13 COTTON BELT #002 BLACK
41157 ANIMALIA ANAN18S-AC13 COTTON BELT #002 WHITE
52828 Subciety CAUCHO BELT BLACK
52829 Subciety CAUCHO BELT NAVY/BURGUNDY
52830 Subciety CAUCHO BELT NAVY/GREEN
57952 Subciety (サブサエティ) CAUCHO BELT - NAVY/BURGUNDY
57953 Subciety (サブサエティ) CAUCHO BELT - NAVY/GREEN
70879 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt BLACK
70880 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt NAVY
70881 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt OD
6470 NineMicrophones G.I BELT Black
6471 NineMicrophones G.I BELT Blue
6472 NineMicrophones G.I BELT Beige
6473 NineMicrophones G.I BELT Khaki
18621 Subciety G.I.BELT - BLACK/WHITE
18622 Subciety G.I.BELT - BLACK/BURGUNDY
18623 Subciety G.I.BELT - BURGUNDY
18624 Subciety G.I.BELT - BEIGE
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
42553 DISTURBIA CLOTHING Chainz Belt
50129 SILLENT FROM ME KNOWN -G.I Web Belt- BLACK/WHITE
50130 SILLENT FROM ME KNOWN -G.I Web Belt- BLACK/BLACK
50307 LILWHITE(dot) LW-19AW-A03 REFLECTOR LONG BELT (BLK)
50308 LILWHITE(dot) LW-19AW-A02 REFLECTOR LONG BELT (LIME)
37770 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW BLK
37771 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW NAVY
37772 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW OLIVE
13259 LOWLIFE Thrash Digtal print
13260 LOWLIFE MIX Degital Print
20030 LOWLIFE Cover Up Neon Pink
48549 ROLLING CRADLE RING BELT / Pink
48550 ROLLING CRADLE RING BELT / Purple
48551 ROLLING CRADLE RING BELT / Blue
54533 SAMURAI CORE SR-AC-032C 夜露死苦哀愁 ガチャベルト WHITE
54534 SAMURAI CORE SR-AC-032C 夜露死苦哀愁 ガチャベルト BLACK
54535 SAMURAI CORE SR-AC-032C 夜露死苦哀愁 ガチャベルト RED
65653 SAMURAI CORE(サムライコア) 初期衝動宣言BELT BLACK
65655 SAMURAI CORE(サムライコア) 初期衝動宣言BELT WHITE
8460 raise 8 apparel NY leather belt BLACK
8461 raise 8 apparel NY leather belt RED
33770 ANIMALIA AN17U-AC19 COTTON BELT 17SU TURQUOISE
33774 ANIMALIA AN17U-AC19 COTTON BELT 17SU BLUE
33777 ANIMALIA AN17U-AC19 COTTON BELT 17SU RED
33778 ANIMALIA AN17U-AC19 COTTON BELT 17SU PINK
54723 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 クリアベルト CLEAR
54724 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 クリアベルト YELLOW
65299 花巻 乙和×DI:VISION コラボ 限定 ガチャベルト
35151 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT RED
35152 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT ORANGE
35153 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT BLACK/RED
35154 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT BLACK/WHITE
40977 LILWHITE(dot) (リルホワイトドット) LW-18SU-A01 -DIVIDED- LONG BELT BLKxWHT
40978 LILWHITE(dot) (リルホワイトドット) LW-18SU-A01 -DIVIDED- LONG BELT BLKxRED