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-03-29 09:12:56')
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)
LIMIT 0, 120
16840 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLACK
16841 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLK/BGN
16843 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- NAVY
16850 ZEPHYREN (ゼファレン) PARKA -RAMPAGE- NAVY
16852 ZEPHYREN (ゼファレン) ZIP PARKA -RAMPAGE- GRAY
34082 Zephyren(ゼファレン) ZIP PARKA -glossy girl- WHITE
34084 Zephyren(ゼファレン) ZIP PARKA -glossy girl- BLACK
34085 Zephyren(ゼファレン) ZIP PARKA -melt hand- WHITE
34086 Zephyren(ゼファレン) ZIP PARKA -melt hand- BLACK×WHITE
34087 Zephyren(ゼファレン) ZIP PARKA -melt hand- BLACK×RED
34089 Zephyren(ゼファレン) ZIP PARKA -melt hand- PURPLE
34999 Zephyren BIG ZIP HOODY S/S-ENGRAVE- WHITE
35000 Zephyren BIG ZIP HOODY S/S-ENGRAVE- BLACK
51936 Zephyren(ゼファレン) ZIP PARKA - Gott Ist Todt - WHITE
16944 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- BURGUNDY
59546 Zephyren(ゼファレン) PAISLEY PARKA RED
26286 Zephyren (ゼファレン) SWITCHING S/S HOODY -VISIONARY- WHITExPAISLEY
26287 Zephyren (ゼファレン) SWITCHING S/S HOODY -VISIONARY- NAVYxPAISLEY
23898 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- CHA/PAI
23899 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- BLK/CHK
15235 ZEPHYREN (ゼファレン) PARKA -Script- BLK
15238 ZEPHYREN (ゼファレン) PARKA -Script- NVY
15649 ZEPHYREN (ゼファレン) PARKA -Determination- BLK
15651 ZEPHYREN (ゼファレン) PARKA -Determination- GRY
15971 ZEPHYREN (ゼファレン) PARKA -NEVER DESPAIR- BLK
19792 ZEPHYREN (ゼファレン) PARKA -VISIONARY- NAVY
15232 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- BLK×BGN
15645 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK
15646 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK×BGN
17599 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLK×BGN
19523 ZEPHYREN (ゼファレン) PARKA -BEYOND - GRAY
22549 Zephyren (ゼファレン) PARKA -PAISLEY- GRY
27159 Zephyren (ゼファレン) LIGHT WEIGHT PARKA -SPADE- GRAY
27171 Zephyren (ゼファレン) LIGHT WEIGHT PARKA -Ace of spades- BLACK
27172 Zephyren (ゼファレン) LIGHT WEIGHT PARKA -Ace of spades- GRAY
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
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
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
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
59872 NEMOPHILA×ZEPHYREN×GEKIROCK CLOTHING コラボ・パーカー
19380 ZEPHYREN (ゼファレン) SUBLIMATION PARKA - BLK PAISLEY
22744 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK x WHITE
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
27106 Zephyren (ゼファレン) CAMOUFLAGE QUILT ZIP PARKA BLACK
27107 Zephyren (ゼファレン) CAMOUFLAGE QUILT ZIP PARKA GREEN
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