SELECT SQL_CALC_FOUND_ROWS 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 =393
)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-20 12:31:15')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 447)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
57102 Zephyren 2021 NEW YEAR BAG
41969 Zephyren(ゼファレン) JERSEY HOOD BLACK
19371 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA GRAY
24783 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
35806 Zephyren (ゼファレン) BIG ZIP PARKA BLACK
59434 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - GRAY
59435 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - KHAKI
59543 Zephyren(ゼファレン) PAISLEY PARKA BLACK
27196 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- GRAY
50117 Zephyren(ゼファレン) ZIP PARKA - Ingrain - BLACK
50118 Zephyren(ゼファレン) ZIP PARKA - Ingrain - WHITE
51937 Zephyren(ゼファレン) ZIP PARKA - Gott Ist Todt - BLACK
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
19506 Zephyren ZIP PARKA -EMBLEM - WHITE
19508 Zephyren ZIP PARKA -EMBLEM - BLACK×BLACK
22887 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/WHITE
22888 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/BURGUNDY
50119 Zephyren(ゼファレン) ZIP PARKA - GIRL BUNNY - BLACK
50120 Zephyren(ゼファレン) ZIP PARKA - GIRL BUNNY - YELLOW
50122 Zephyren(ゼファレン) ZIP PARKA - GIRL TATTOO - PURPLE
55098 Zephyren(ゼファレン)ZIP PARKA - As above,So below - WHITE
55099 Zephyren(ゼファレン)ZIP PARKA - As above,So below - BLACK
20037 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLACK
22544 Zephyren (ゼファレン) DENIM SWEAT -HIGHEST- DENIM ZIP PARKA
48807 Zephyren(ゼファレン) ZIP PARKA - As above, So below - BLACK
49952 Zephyren(ゼファレン) ZIP PARKA - As above, So below - WHITE
49953 Zephyren(ゼファレン) ZIP PARKA - As above, So below - GRAY
52417 Zephyren 2020 NEW YEAR BAG
41971 Zephyren(ゼファレン) JERSEY HOOD MAXIM
27057 Zephyren (ゼファレン) BOA LONG ZIP PARKA WHITE
27058 Zephyren (ゼファレン) BOA LONG ZIP PARKA BLACK
35823 Zephyren (ゼファレン) BOA ZIP PARKA WHITE
35824 Zephyren (ゼファレン) BOA ZIP PARKA BLACK
27106 Zephyren (ゼファレン) CAMOUFLAGE QUILT ZIP PARKA BLACK
27107 Zephyren (ゼファレン) CAMOUFLAGE QUILT ZIP PARKA GREEN
19370 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA -Resolve - BLACK
19372 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
19379 ZEPHYREN (ゼファレン) SUBLIMATION ZIP PARKA - ORG VOID
22642 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE ZIP PARKA -Resolve- CAMO I
22643 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE ZIP PARKA -Resolve- CAMO II
22647 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BLACK x WHITE
22648 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BLACK
22649 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BURGUNDY
22653 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK
22654 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BURGUNDY
27094 Zephyren (ゼファレン) SPADE TRIBAL ZIP PARKA WHITExBLACK
27095 Zephyren (ゼファレン) SPADE TRIBAL ZIP PARKA BLACK
30243 Zephyren(ゼファレン) ZIP PARKA -X-RAY SKULL- BIGSKULL
30413 Zephyren(ゼファレン) STUDS ZIP PARKA BLACKxSILVER
30415 Zephyren(ゼファレン) STUDS ZIP PARKA GRAYxSILVER
19380 ZEPHYREN (ゼファレン) SUBLIMATION PARKA - BLK PAISLEY
22744 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK x WHITE
59872 NEMOPHILA×ZEPHYREN×GEKIROCK CLOTHING コラボ・パーカー
22568 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x PAISLEY
22569 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- CHACOAL x PAISLEY
22570 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x CHECK
22571 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- CHACOAL x CHECK
19397 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - BLK/PRAY FOR DESTROY
19398 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - GRY/PRAY FOR DESTROY
19400 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - BLK/Charmed SQ Tone
19401 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - GRY/Charmed SQ Tone
19406 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - BLACK
30153 Zephyren(ゼファレン) ZIP PARKA -CocaCola- WHITE
30154 Zephyren(ゼファレン) ZIP PARKA -CocaCola- BLACK
59433 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - BLACK
16842 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- GRAY
24715 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- BLACK x PAISLEY
24716 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- CHACOAL x PAISLEY
24717 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- BLACK x CHECK
24718 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- CHACOAL x CHECK
25117 Zephyren (ゼファレン) HOOD SHIRT S/S -SPADE- BURGUNDY
25118 Zephyren (ゼファレン) HOOD SHIRT S/S -SPADE- BLACK
25119 Zephyren (ゼファレン) HOOD SHIRT S/S -SPADE- WHITE
27125 Zephyren (ゼファレン) LONG ZIP PARKA -SPADE- BLACK
27127 Zephyren (ゼファレン) LONG ZIP PARKA -SPADE- GRAY
27195 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- BLACK
27198 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- DENIM
27199 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -SPADE- WHITE
27200 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -SPADE- BLACK
27201 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -SPADE- GRAY
34088 Zephyren(ゼファレン) ZIP PARKA -melt hand- BURGUNDY
38333 Zephyren (ゼファレン) BANDANA ZIP PARKA -TRUST- WHITE
38334 Zephyren (ゼファレン) BANDANA ZIP PARKA -TRUST- BLACKxNAVY
38335 Zephyren (ゼファレン) BANDANA ZIP PARKA -TRUST- BLACKxBLACK
42135 Zephyren(ゼファレン) ZIP PARKA -PLEDGE- BLACK
45976 Zephyren(ゼファレン)ZIP PARKA -alea iacta est / milestone- BLACK
45977 Zephyren(ゼファレン)ZIP PARKA -alea iacta est / milestone- GRAY
55106 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - WHITE
15233 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- GRY
19499 Zephyren (ゼファレン) ZIP PARKA -SKULL HEAD - WHITE
19509 Zephyren ZIP PARKA -EMBLEM - GRAY
22351 Zephyren (ゼファレン) ZIP PARKA -Scream of Aggression- WHT/BLU
22352 Zephyren (ゼファレン) ZIP PARKA -Scream of Aggression- BLK/BLU
22889 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- GRAY
22890 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLUE
26881 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -BEYOND- BLACKxRED
26882 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -BEYOND- BLACKxBLUE
26890 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE- BLACK
26894 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE- BLACKxRED
26895 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE- BLACKxBLUE
26896 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -PAISLEY- WHITE
26897 Zephyren (ゼファレン) LIGHT WEIGHT ZIP PARKA -PAISLEY- BLACKx WHITE
27113 Zephyren (ゼファレン) BIG HOOD PARKA -Resolve- BLACK
27114 Zephyren (ゼファレン) BIG HOOD PARKA -Resolve- GRAY
30255 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE- BLACK
30262 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -ENGRAVE- BLACKxWHITE
30265 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -ENGRAVE- GRAY
30269 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE FLAME- BLACKxWHITE
35437 Zephyren (ゼファレン) ZIP PARKA -Inhale the black- WHITE
35438 Zephyren (ゼファレン) ZIP PARKA -Inhale the black- BLACKxNAVY
35440 Zephyren (ゼファレン) ZIP PARKA -Inhale the black- GRAYxBLACKHOOD
38344 Zephyren (ゼファレン) ZIP PARKA -MEMENTO MORI- BLACK
42139 Zephyren(ゼファレン) ZIP PARKA -DOOR- WHITE
42143 Zephyren(ゼファレン) ZIP PARKA -PRAY- WHITE / COLOR
15232 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- BLK×BGN
15645 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK
15646 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK×BGN