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-19 11:53:39')
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 p.update_date DESC
LIMIT 0, 120
61271 Zephyren 2022 NEW YEAR BAG
59872 NEMOPHILA×ZEPHYREN×GEKIROCK CLOTHING コラボ・パーカー
59434 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - GRAY
59435 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - KHAKI
59433 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - BLACK
59543 Zephyren(ゼファレン) PAISLEY PARKA BLACK
59546 Zephyren(ゼファレン) PAISLEY PARKA RED
57102 Zephyren 2021 NEW YEAR BAG
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
55106 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - WHITE
55098 Zephyren(ゼファレン)ZIP PARKA - As above,So below - WHITE
55099 Zephyren(ゼファレン)ZIP PARKA - As above,So below - BLACK
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15232 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- BLK×BGN
15233 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- GRY
15235 ZEPHYREN (ゼファレン) PARKA -Script- BLK
15238 ZEPHYREN (ゼファレン) PARKA -Script- NVY
15645 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK
15646 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK×BGN
15649 ZEPHYREN (ゼファレン) PARKA -Determination- BLK
15651 ZEPHYREN (ゼファレン) PARKA -Determination- GRY
15971 ZEPHYREN (ゼファレン) PARKA -NEVER DESPAIR- BLK
16840 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLACK
16841 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLK/BGN
16842 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- GRAY
16843 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- NAVY
16850 ZEPHYREN (ゼファレン) PARKA -RAMPAGE- NAVY
16852 ZEPHYREN (ゼファレン) ZIP PARKA -RAMPAGE- GRAY
16944 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- BURGUNDY
17599 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLK×BGN
19370 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA -Resolve - BLACK
19371 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA GRAY
19372 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
19379 ZEPHYREN (ゼファレン) SUBLIMATION ZIP PARKA - ORG VOID
19380 ZEPHYREN (ゼファレン) SUBLIMATION PARKA - BLK PAISLEY
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
19499 Zephyren (ゼファレン) ZIP PARKA -SKULL HEAD - WHITE
19506 Zephyren ZIP PARKA -EMBLEM - WHITE
19508 Zephyren ZIP PARKA -EMBLEM - BLACK×BLACK
19509 Zephyren ZIP PARKA -EMBLEM - GRAY
19523 ZEPHYREN (ゼファレン) PARKA -BEYOND - GRAY
19792 ZEPHYREN (ゼファレン) PARKA -VISIONARY- NAVY
20037 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLACK
22351 Zephyren (ゼファレン) ZIP PARKA -Scream of Aggression- WHT/BLU
22352 Zephyren (ゼファレン) ZIP PARKA -Scream of Aggression- BLK/BLU
22544 Zephyren (ゼファレン) DENIM SWEAT -HIGHEST- DENIM ZIP PARKA
22549 Zephyren (ゼファレン) PARKA -PAISLEY- GRY
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
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
22744 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK x WHITE
22887 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/WHITE
22888 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/BURGUNDY
22889 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- GRAY
22890 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLUE
23898 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- CHA/PAI
23899 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- BLK/CHK
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
24783 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
25117 Zephyren (ゼファレン) HOOD SHIRT S/S -SPADE- BURGUNDY
25118 Zephyren (ゼファレン) HOOD SHIRT S/S -SPADE- BLACK
25119 Zephyren (ゼファレン) HOOD SHIRT S/S -SPADE- WHITE
26286 Zephyren (ゼファレン) SWITCHING S/S HOODY -VISIONARY- WHITExPAISLEY
26287 Zephyren (ゼファレン) SWITCHING S/S HOODY -VISIONARY- NAVYxPAISLEY
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
27057 Zephyren (ゼファレン) BOA LONG ZIP PARKA WHITE
27058 Zephyren (ゼファレン) BOA LONG ZIP PARKA BLACK
27094 Zephyren (ゼファレン) SPADE TRIBAL ZIP PARKA WHITExBLACK
27095 Zephyren (ゼファレン) SPADE TRIBAL ZIP PARKA BLACK
27106 Zephyren (ゼファレン) CAMOUFLAGE QUILT ZIP PARKA BLACK
27107 Zephyren (ゼファレン) CAMOUFLAGE QUILT ZIP PARKA GREEN
27113 Zephyren (ゼファレン) BIG HOOD PARKA -Resolve- BLACK
27114 Zephyren (ゼファレン) BIG HOOD PARKA -Resolve- GRAY
27125 Zephyren (ゼファレン) LONG ZIP PARKA -SPADE- BLACK
27127 Zephyren (ゼファレン) LONG ZIP PARKA -SPADE- GRAY
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
27195 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- BLACK
27196 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- GRAY
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
30153 Zephyren(ゼファレン) ZIP PARKA -CocaCola- WHITE
30154 Zephyren(ゼファレン) ZIP PARKA -CocaCola- BLACK
30243 Zephyren(ゼファレン) ZIP PARKA -X-RAY SKULL- BIGSKULL
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
30413 Zephyren(ゼファレン) STUDS ZIP PARKA BLACKxSILVER
30415 Zephyren(ゼファレン) STUDS ZIP PARKA GRAYxSILVER
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
34088 Zephyren(ゼファレン) ZIP PARKA -melt hand- BURGUNDY