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-27 08:51: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 120, 120
59480 Zephyren(ゼファレン) FUR COAT BLACK
59481 Zephyren(ゼファレン) FUR COAT BROWN
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
59535 Zephyren(ゼファレン) BIG SHIRT L/S NAVY / PAISLEY
59536 Zephyren(ゼファレン) BIG SHIRT L/S DRAGONFLY
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
59539 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S MIX
59515 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK / Creux
59550 Zephyren(ゼファレン) JACQUARD CUT L/S WHITE
59551 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK
59552 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK / MIX
59553 Zephyren(ゼファレン) JACQUARD CUT L/S GREEN / MIX
59507 Zephyren(ゼファレン) SHIRT L/S - Resolve - BLACK / PAISLEY
59670 Zephyren(ゼファレン) EASY PANTS FLOWER
59672 Zephyren(ゼファレン) EASY PANTS 8/S GREEN CHECK
59674 Zephyren(ゼファレン) EASY PANTS 8/S FLOWER
57583 Zephyren(ゼファレン) EASY PANTS BROWN CHECK
57587 Zephyren(ゼファレン) EASY PANTS 8/S BROWN CHECK
59717 Zephyren(ゼファレン) LONG BEANIE -You Are Here WHITE
59718 Zephyren(ゼファレン) LONG BEANIE -You Are Here BLACK
59723 Zephyren(ゼファレン) LONG BEANIE -You Are Here PURPLE
59724 Zephyren(ゼファレン) LONG BEANIE -You Are Here ORANGE
59439 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / RED
59599 Zephyren(ゼファレン) L/S TEE - twilight - WHITE
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
59603 Zephyren(ゼファレン) BIG L/S TEE - jua - WHITE
50513 Zephyren(ゼファレン) PARKA -PROVE- BLACK
59651 Zephyren(ゼファレン) PARKA - Elysium - YELLOW
59647 Zephyren(ゼファレン) PARKA - Elysium - BLACK
27138 Zephyren (ゼファレン) PARKA -BEYOND- WHITE
27139 Zephyren (ゼファレン) PARKA -BEYOND- BLACK
42165 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
50514 Zephyren(ゼファレン) PARKA -PROVE- GRAY
57494 Zephyren(ゼファレン) SWITCHING TEE BLACK / BORDER
49887 Zephyren(ゼファレン)LONG CHECK SHIRT S/S BLACK
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
59472 【予約商品】Zephyren(ゼファレン) COACH JACKET BLACK / Reverie
59475 【予約商品】Zephyren(ゼファレン) COACH JACKET BLACK / twilight
59490 Zephyren(ゼファレン) LONG COAT D.GREEN / CHECK
59546 Zephyren(ゼファレン) PAISLEY PARKA RED
59604 Zephyren(ゼファレン) BIG L/S TEE - jua - BLACK
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
57438 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BLACK
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57451 Zephyren(ゼファレン) SHIRT S/S - Resolve - FLOWER
57496 Zephyren(ゼファレン) SWITCHING TEE BLACK / FLOWER
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
15225 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- WHT
42101 Zephyren(ゼファレン) S/S TEE -BEYOND- STONE
55063 Zephyren(ゼファレン)S/S TEE - BEYOND - AQUA
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
50216 Zephyren(ゼファレン) BUCKET HAT - PROVE - WHITE
57629 Zephyren(ゼファレン) BUCKET HAT -PROVE- BLACK
57594 Zephyren(ゼファレン) SHORTS BROWN CHECK
57590 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK
57597 Zephyren(ゼファレン) DOUBLE POCKET SHORTS BLACK
57468 Zephyren(ゼファレン) DOLMAN BIG TEE S/S WHITE / NEVER say NEVER
26608 Zephyren (ゼファレン) PAISLEY WATCH BLACK
15221 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- WHT
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
57439 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BURGUNDY
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
57596 Zephyren(ゼファレン) SHORTS PAISLEY
54999 Zephyren(ゼファレン)LONG SHIRT L/S FLOWER
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
35969 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- WHITE
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
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
33267 Zephyren (ゼファレン) RUBBER RING -VISIONARY- WHITE
33268 Zephyren (ゼファレン) RUBBER RING -VISIONARY- BLACK
36037 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- BLACK
36038 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- KHAKI
45602 Zephyren(ゼファレン)LO CAP - PROVE - BLACK
50215 Zephyren(ゼファレン) BUCKET HAT - PROVE - BLACK
57580 【予約商品】Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
57610 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / WHITE
57616 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / GRAY
57623 【予約商品】Zephyren(ゼファレン) LO CAP -PROVE- BLACK
57628 【予約商品】Zephyren(ゼファレン) BUCKET HAT -PROVE- WHITE
57538 Zephyren(ゼファレン) S/S TEE - Melencolia - BLACK
57102 Zephyren 2021 NEW YEAR BAG
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
55039 Zephyren(ゼファレン)FUR PARKA WHITE
55040 Zephyren(ゼファレン)FUR PARKA BLACK
54983 Zephyren(ゼファレン)FUR JACKET BLACK
55021 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - MUSTARD
55020 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - GREEN
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
55011 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - BLACK
55226 Zephyren(ゼファレン)PAISLEY G.I BELT BEIGE
55780 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 コーチJKT
55779 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 L/S Tシャツ
55778 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 キャップ
55022 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - WHITE
55023 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - BLACK
55025 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - MUSTARD
54955 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - BLACK
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK
54954 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - KHAKI
54970 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - BLACK