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 dtb_products AS p
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-05-01 16:06:21')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 14,61,35)
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
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
68007 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ プルオーバーパーカー
68008 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ Tシャツ
66722 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise MOCK NECK LOOSE SWEAT BK
66725 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA BLACK
66492 10-FEET×Zephyren(ゼファレン) TRACK JACET BLACK
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66494 10-FEET×Zephyren(ゼファレン) BIG PARKA BlackxBlack
66497 10-FEET×Zephyren(ゼファレン) DOLMAN BIG TEE BLACK
66501 10-FEET×Zephyren(ゼファレン) SWEAT PANTS BLACK
66502 10-FEET×Zephyren(ゼファレン) SWEAT PANTS BlackxBlack
62239 Zephyren(ゼファレン) SWITCHING TEE PAISLEY
62240 Zephyren(ゼファレン) SWITCHING TEE BORDER
62241 Zephyren(ゼファレン) SWITCHING TEE THUNDER
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
62228 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - BLACK / DRAGONFLY
62226 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - FLOWER
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
62347 Zephyren(ゼファレン) SHORTS BLACK / DRAGONFLY
62344 Zephyren(ゼファレン) SHORTS FLOWER
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
59493 Zephyren(ゼファレン) EMBLEM SHIRT L/S BLACK
59499 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - BLACK
62288 Zephyren(ゼファレン) S/S TEE - FEAR NO ONE - BLACK
62293 Zephyren(ゼファレン) S/S TEE - In vino veritas - BLACK
62238 Zephyren(ゼファレン) SWITCHING TEE FLOWER
62266 Zephyren(ゼファレン) S/S TEE - BEYOND - BLACK
62342 Zephyren(ゼファレン) EASY PANTS 8/S BLACK / DRAGONFLY
59458 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK
59461 Zephyren(ゼファレン) WIDE TAILORD JACKET FLOWER
59676 Zephyren(ゼファレン) JERSEY PANTS BLACK / RED
59500 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - FLOWER
27139 Zephyren (ゼファレン) PARKA -BEYOND- BLACK
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
57590 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK
57597 Zephyren(ゼファレン) DOUBLE POCKET SHORTS BLACK
57598 Zephyren(ゼファレン) DOUBLE POCKET SHORTS PAISLEY
52048 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK
52049 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
55156 Zephyren(ゼファレン)WIDE SLACKS TWEED
54967 Zephyren(ゼファレン)WIDE TAILORD JACKET BLACK
55023 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - BLACK
19298 ZEPHYREN (ゼファレン) EMBLEM SHIRT L/S - BLACK
30211 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- BLACK
24943 Zephyren (ゼファレン) S/S TEE -BEYOND- BLACKxBLACK
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
53268 Zephyren(ゼファレン)DOLMAN BIG HOODY S/S BLACK
53252 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / TIGER
52046 Zephyren(ゼファレン) CLASHED SKINNY BLACK.DENIM
52045 Zephyren(ゼファレン) CLASHED SKINNY BLACK
52059 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK/Pagan
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
53242 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / RED
15215 ZEPHYREN (ゼファレン) TEE S/S -Script- BLK×BGN
15217 Zephyren(ゼファレン)S/S TEE -SKULL HEAD- BLACK
15223 ZEPHYREN (ゼファレン) TEE S/S -VISONARY- BLK×GLD
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15232 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- BLK×BGN
15236 ZEPHYREN (ゼファレン) PARKA -Script- BLK×BGN
15239 ZEPHYREN (ゼファレン) PARKA -VISIONARY- BLACK
15244 ZEPHYREN (ゼファレン) PARKA -BEYOND- BLK×GLD
15624 ZEPHYREN (ゼファレン) TEE L/S -Skul head- BLK
15645 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK
15650 ZEPHYREN (ゼファレン) PARKA -Determination- BLK×BGN
15653 ZEPHYREN (ゼファレン) SWEAT -Skull head- BLK
15657 ZEPHYREN (ゼファレン) SWEAT -Script- BLK
15659 ZEPHYREN (ゼファレン) SWEAT -Script- BLK×GLD
15662 ZEPHYREN (ゼファレン) SWEAT -VISIONARY- BLK
16840 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLACK
16841 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLK/BGN
16844 ZEPHYREN (ゼファレン) PARKA -THE SUN- BLACK
16845 ZEPHYREN (ゼファレン) PARKA -THE SUN- BLK/BGN
16848 ZEPHYREN (ゼファレン) PARKA -RAMPAGE- BLACK
16853 ZEPHYREN (ゼファレン) ZIP PARKA -RAMPAGE- BLACK
16943 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- BLACK
16967 ZEPHYREN (ゼファレン) S/S TEE -THE VOID- - BLACK
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
17041 ZEPHYREN (ゼファレン) S/S TEE -Charmed SQ tone- BLACK×BURGUNDY
17090 Zephyren VNECK S/S -Resolve- - BLACK
17167 ZEPHYREN (ゼファレン) S/S-TEE -reaper- BLACK
17589 ZEPHYREN (ゼファレン) PARKA -Never Despair- BLK/BGN
17599 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLK×BGN
18119 ZEPHYREN (ゼファレン) WORK SHIRT S/S -10-FEET BLK
19029 ZEPHYREN (ゼファレン) METAL RING -SKULL HEAD- BLACK
19195 ZEPHYREN (ゼファレン) SWING TOP -Charmed SQ Tone - BLACK
19268 Zephyren (ゼファレン) CHESTERFIELD COAT - BLACK
19310 ZEPHYREN (ゼファレン) PAISLEY POCKET SHIRT L/S - BLACK
19312 ZEPHYREN (ゼファレン) PAISLEY POCKET SHIRT L/S - BLACK/STRIPE
19352 ZEPHYREN (ゼファレン) EMBLEM CARDIGAN - BLACK
19367 ZEPHYREN (ゼファレン) FLEECE STRIPE PARKA -Resolve - BLACK
19370 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA -Resolve - BLACK
19400 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - BLK/Charmed SQ Tone
19452 ZEPHYREN (ゼファレン) R-7/S TEE -BEYOND - BLACK/WHITE
19466 ZEPHYREN (ゼファレン) L/S TEE -BEYOND - BLACK×WHITE
19472 ZEPHYREN (ゼファレン) L/S TEE -SKULL HEAD - BLACK×WHITE
19473 ZEPHYREN (ゼファレン) L/S TEE -SKULL HEAD - BLACK×BURGUNDY
19508 Zephyren ZIP PARKA -EMBLEM - BLACK×BLACK
19529 Zephyren PARKA -EMBLEM - BLACK×BLACK
19570 ZEPHYREN (ゼファレン) SWEAT -SKULL HEAD - BLACK
19577 Zephyren (ゼファレン) PATCH SWEAT -VISIONARY - BLACK
19608 Zephyren STADS WORK PANTS - BLACK
19720 ZEPHYREN (ゼファレン) METAL RING -THORN - BLACK
20037 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLACK
20214 ZEPHYREN (ゼファレン) S/S-TEE -EMBLEM- BLK/WHT
20215 ZEPHYREN (ゼファレン) S/S-TEE -EMBLEM- BLK/BLK
21388 ZEPHYREN (ゼファレン) VNECK TEE -SKULL HEAD- BLACK
22353 Zephyren (ゼファレン) PARKA -BEYOND- BLK/BLK
22355 Zephyren (ゼファレン) PARKA -Zephees- BLK
22519 Zephyren (ゼファレン) COACH JKT -BEYOND- BLACK/GREEN
22520 Zephyren (ゼファレン) COACH JKT -BEYOND- BLACK/WHITE
22521 Zephyren (ゼファレン) NYLON STUDIUM JKT -BEYOND- BLACK/WHITE
22523 Zephyren (ゼファレン) EMBLEM CARDIGAN - BLACK
22539 Zephyren (ゼファレン) SWITCHING LONG SHIRT -Resolve- BLACK x CAMO
22568 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x PAISLEY
22570 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x CHECK
22591 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- BLACK
22651 Zephyren (ゼファレン) PARKA -PROVIDENCE- BLACK
22742 Zephyren (ゼファレン) SAFARI JKT BLACK x CAMO