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 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-04-18 22:14:07')
AND FIND_IN_SET(1, p.color)
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
70909 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BLACK
70906 優里xZEPHYREN -Betelgeuse- PARKA BLACK
70703 MY FIRST STORY×Zephyren - Fight Back 23 - STUDIUM JACKET BLACKxWHITE
70704 MY FIRST STORY×Zephyren - Fight Back 23 - NYLON JACKET BLACK
70701 MY FIRST STORY×Zephyren - Fight Back 23 - BIG PARKA BLACK
70702 MY FIRST STORY×Zephyren - Fight Back 23 - BIG SWEAT BLACK
70697 優里xZephyren -Betelgeuse- JACQUARD KNIT BLACK
70699 優里xZephyren -Betelgeuse- S/S TEE 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
61271 Zephyren 2022 NEW YEAR BAG
17231 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- - BLACK/WHITE
17236 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BLACK/GRAY
17257 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY- BLACK/WHITE
19657 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - BLACK/GRAY
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
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
59493 Zephyren(ゼファレン) EMBLEM SHIRT L/S BLACK
59499 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - BLACK
62243 Zephyren(ゼファレン) JACQUARD SUMMER KNIT BLACK
62244 Zephyren(ゼファレン) JACQUARD SUMMER KNIT BLACK / CHARCOAL
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
62316 Zephyren(ゼファレン) TANKTOP - In vino veritas - BLACK
62342 Zephyren(ゼファレン) EASY PANTS 8/S BLACK / DRAGONFLY
52479 【バンドリ!×ゲキクロ 第4弾復刻】ZEPHYREN×氷川 日菜コラボ 限定 ビーニー
59488 Zephyren(ゼファレン) LONG COAT BLACK
59458 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK
59461 Zephyren(ゼファレン) WIDE TAILORD JACKET FLOWER
59438 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / BLACK
59440 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO / BLACK
59448 Zephyren(ゼファレン) TRENCH COAT FLOWER
59446 Zephyren(ゼファレン) TRENCH COAT BLACK
59433 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - BLACK
59540 Zephyren(ゼファレン) LINE PARKA - VISIONARY - BLACK
59543 Zephyren(ゼファレン) PAISLEY PARKA BLACK
59520 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK / Reverie
59428 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - BLACK
59479 Zephyren(ゼファレン) STUDIUM JACKET MIX
59480 Zephyren(ゼファレン) FUR COAT BLACK
59676 Zephyren(ゼファレン) JERSEY PANTS BLACK / RED
59444 Zephyren(ゼファレン) MA-1 Type BLOUSON FLOWER
59456 Zephyren(ゼファレン) MA-1 BLACK
59457 Zephyren(ゼファレン) MA-1 FLOWER
59500 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - FLOWER
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
59515 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK / Creux
59551 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK
59552 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK / MIX
59507 Zephyren(ゼファレン) SHIRT L/S - Resolve - BLACK / PAISLEY
59718 Zephyren(ゼファレン) LONG BEANIE -You Are Here BLACK
59439 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / RED
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
50513 Zephyren(ゼファレン) PARKA -PROVE- BLACK
59647 Zephyren(ゼファレン) PARKA - Elysium - BLACK
27139 Zephyren (ゼファレン) PARKA -BEYOND- BLACK
57494 Zephyren(ゼファレン) SWITCHING TEE BLACK / BORDER
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
59604 Zephyren(ゼファレン) BIG L/S TEE - jua - BLACK
57438 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BLACK
57451 Zephyren(ゼファレン) SHIRT S/S - Resolve - FLOWER
57496 Zephyren(ゼファレン) SWITCHING TEE BLACK / FLOWER
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
57590 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK
57597 Zephyren(ゼファレン) DOUBLE POCKET SHORTS BLACK
26608 Zephyren (ゼファレン) PAISLEY WATCH BLACK
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
35970 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BLACK
57598 Zephyren(ゼファレン) DOUBLE POCKET SHORTS PAISLEY
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
57495 Zephyren(ゼファレン) SWITCHING TEE BLACK / PYTHON
52048 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK
52049 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
57724 Zephyren(ゼファレン) iPhone CASE -音のない世界(I Scream)- iPHONE 12/12 Pro
57752 Zephyren(ゼファレン) SHOWER SANDALS - Decadence - BLACK
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
33268 Zephyren (ゼファレン) RUBBER RING -VISIONARY- BLACK
36037 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- BLACK
50215 Zephyren(ゼファレン) BUCKET HAT - PROVE - BLACK
57610 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / WHITE
57616 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / GRAY
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
55156 Zephyren(ゼファレン)WIDE SLACKS TWEED
54985 Zephyren(ゼファレン)TRENCH COAT BLACK
54967 Zephyren(ゼファレン)WIDE TAILORD JACKET BLACK
55040 Zephyren(ゼファレン)FUR PARKA BLACK
54983 Zephyren(ゼファレン)FUR JACKET BLACK
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
55011 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - BLACK
55023 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - BLACK
54955 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - BLACK
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK