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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)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-05-01 22:48:31')
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, 240
70705 MY FIRST STORY×Zephyren - Fight Back 23 - BIG TEE BLACK
70699 優里xZephyren -Betelgeuse- S/S TEE BLACK
70700 優里xZephyren -Betelgeuse- S/S TEE WHITE
68008 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ Tシャツ
66497 10-FEET×Zephyren(ゼファレン) DOLMAN BIG TEE BLACK
66499 10-FEET×Zephyren(ゼファレン) DOLMAN BIG TEE WHITE
64589 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
64599 【予約商品】Zephyren(ゼファレン)S/S TEE - BEYOND - WHITE
64600 【予約商品】Zephyren(ゼファレン)S/S TEE - BEYOND - BLACK
62239 Zephyren(ゼファレン) SWITCHING TEE PAISLEY
62240 Zephyren(ゼファレン) SWITCHING TEE BORDER
62241 Zephyren(ゼファレン) SWITCHING TEE THUNDER
62294 Zephyren(ゼファレン) S/S TEE - In vino veritas - YELLOW
62288 Zephyren(ゼファレン) S/S TEE - FEAR NO ONE - BLACK
62293 Zephyren(ゼファレン) S/S TEE - In vino veritas - BLACK
62296 Zephyren(ゼファレン) S/S TEE - In vino veritas - STONE
62238 Zephyren(ゼファレン) SWITCHING TEE FLOWER
62255 Zephyren(ゼファレン) S/S TEE - VISIONARY - WHITE
62266 Zephyren(ゼファレン) S/S TEE - BEYOND - BLACK
62274 Zephyren(ゼファレン) S/S TEE - BEYOND - BLUE
62287 Zephyren(ゼファレン) S/S TEE - FEAR NO ONE - WHITE
52482 【バンドリ!×ゲキクロ 第4弾復刻】ZEPHYREN×氷川 日菜コラボ 限定 Tシャツ
59873 NEMOPHILA×ZEPHYREN×GEKIROCK CLOTHING コラボTシャツ
57494 Zephyren(ゼファレン) SWITCHING TEE BLACK / BORDER
57496 Zephyren(ゼファレン) SWITCHING TEE BLACK / FLOWER
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
42101 Zephyren(ゼファレン) S/S TEE -BEYOND- STONE
55063 Zephyren(ゼファレン)S/S TEE - BEYOND - AQUA
57468 Zephyren(ゼファレン) DOLMAN BIG TEE S/S WHITE / NEVER say NEVER
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
57495 Zephyren(ゼファレン) SWITCHING TEE BLACK / PYTHON
57538 Zephyren(ゼファレン) S/S TEE - Melencolia - BLACK
57102 Zephyren 2021 NEW YEAR BAG
55047 Zephyren(ゼファレン)S/S TEE - VISIONARY - SKY
55066 Zephyren(ゼファレン)S/S TEE - fiat lux - WHITE
55067 Zephyren(ゼファレン)S/S TEE - fiat lux - BLACK
55071 Zephyren(ゼファレン)BIG TEE - VISIONARY / Kaleidoscope - WHITE
55072 Zephyren(ゼファレン)BIG TEE - VISIONARY / Kaleidoscope - BLACK
54489 【バンドリ!×ゲキクロ第1弾復刻】ZEPHYREN×湊友希那コラボ 限定 Tシャツ
53267 Zephyren(ゼファレン)DOLMAN BIG HOODY S/S WHITE
53268 Zephyren(ゼファレン)DOLMAN BIG HOODY S/S BLACK
51894 Zephyren(ゼファレン) PONCHO TEE S/S WHITE / pagan
51895 Zephyren(ゼファレン) PONCHO TEE S/S BLACK / pagan
53249 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE / BURGUNDY
53252 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / TIGER
53251 Zephyren(ゼファレン)SWITCHING TEE S/S WHITE / RELIGION
52023 Zephyren(ゼファレン) S/S TEE -Got lst Todi- BLACK
52036 Zephyren(ゼファレン) BIG S/S TEE -VISIONARY/zebra eye- WHITE
52037 Zephyren(ゼファレン) BIG S/S TEE -VISIONARY/zebra eye- BLACK
52034 Zephyren(ゼファレン) S/S TEE -Raw color- YELLOW
52035 Zephyren(ゼファレン) S/S TEE -Raw color- PURPLE
52033 Zephyren(ゼファレン) S/S TEE -Raw color- BLACK
52032 Zephyren(ゼファレン) S/S TEE -Raw color- WHITE
53242 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / RED
26234 Zephyren (ゼファレン) S/S TEE -Zion- WHITE
26235 Zephyren (ゼファレン) S/S TEE -Zion- BLACKxWHITE
26236 Zephyren (ゼファレン) S/S TEE -Zion- BLACKxRED
26237 Zephyren (ゼファレン) S/S TEE -Zion- BURGUNDY
26238 Zephyren (ゼファレン) S/S TEE -Zion- DARK.GREEN
26239 Zephyren (ゼファレン) S/S TEE -Zion- BLUE
26240 Zephyren (ゼファレン) S/S TEE -SCULPTURE- WHITE
26241 Zephyren (ゼファレン) S/S TEE -SCULPTURE- BLACK
26242 Zephyren (ゼファレン) S/S TEE -Soldier- WHITE
26243 Zephyren (ゼファレン) S/S TEE -Soldier- BLACK
26244 Zephyren (ゼファレン) S/S TEE -Libidinal- WHITE
26245 Zephyren (ゼファレン) S/S TEE -Libidinal- BLACK
26247 Zephyren (ゼファレン) S/S TEE -Ace of spades- WHITE
26248 Zephyren (ゼファレン) S/S TEE -Ace of spades- BLACK
26249 Zephyren (ゼファレン) LONG S/S TEE -Ace of Spades- BLACKxRED
26253 Zephyren (ゼファレン) S/S TEE -Microphone- BLACKxWHITE
26254 Zephyren (ゼファレン) S/S TEE -Microphone- BLACKxMUSTARD
26255 Zephyren (ゼファレン) S/S TEE -Microphone- ASH
26303 Zephyren (ゼファレン) SPADE TRIBAL VNECK TEE WHITE
26304 Zephyren (ゼファレン) SPADE TRIBAL VNECK TEE BLACK
26305 Zephyren (ゼファレン) SPADE TRIBAL VNECK TEE BLACK / WHITE
26309 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- BLACK
26310 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- BURGUNDY
26311 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- NAVY
26312 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- BLACK
26313 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- NAVY
26317 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- BURGUNDY
26323 Zephyren (ゼファレン) SWITCHING VNECK TEE -Resolve- GRAYxPAISLEY
26324 Zephyren (ゼファレン) S/S TEE -Birth pangs- WHITE
26325 Zephyren (ゼファレン) S/S TEE -Birth pangs- BLACK
26326 Zephyren (ゼファレン) SWITCHING VNECK TEE -Resolve- NAVYxPAISLEY
26327 Zephyren (ゼファレン) SWITCHING VNECK TEE -Resolve- BLACKxPAISLEY
26360 Zephyren (ゼファレン) POCKET VNECK -Flow- WHITExPAISLEY
26361 Zephyren (ゼファレン) POCKET VNECK -Flow- BLACKxPAISLEY
26362 Zephyren (ゼファレン) POCKET VNECK -Flow- WHITExSTAR DOT
26363 Zephyren (ゼファレン) POCKET VNECK -Flow- BLACKxSTAR DOT
26364 Zephyren (ゼファレン) LONG S/S TEE -BEYOND- WHITE
26365 Zephyren (ゼファレン) LONG S/S TEE -BEYOND- BLACKxWHITE
26366 Zephyren (ゼファレン) LONG S/S TEE -BEYOND- BLACKxRED
26367 Zephyren (ゼファレン) LONG S/S TEE -BEYOND- GRAY
26368 Zephyren (ゼファレン) LONG S/S TEE -PAISLEY- WHITE
26369 Zephyren (ゼファレン) LONG S/S TEE -PAISLEY- BLACKxWHITE
26370 Zephyren (ゼファレン) LONG S/S TEE -PAISLEY- BLACKxBLACK
26371 Zephyren (ゼファレン) LONG S/S TEE -PAISLEY- GRAY
26372 Zephyren (ゼファレン) LONG S/S TEE -Ace of Spades- WHITE
26373 Zephyren (ゼファレン) LONG S/S TEE -Ace of Spades- BLACKxWHITE
26374 Zephyren (ゼファレン) SWITCHING VNECK TEE -Resolve- WHITExPAISLEY
26552 Zephyren (ゼファレン) SWITCHING S/S HOODY -VISIONARY- BLACKxPAISLEY
26593 Zephyren (ゼファレン) CAMOUFLAGE S/S TEE -BEYOND- CAMO I
26594 Zephyren (ゼファレン) CAMOUFLAGE S/S TEE -BEYOND- CAMO II
26595 Zephyren (ゼファレン) CAMOUFLAGE S/S TEE -BEYOND- CAMO III
26596 Zephyren (ゼファレン) REVERSE S/S TEE PAISLEY
26746 Zephyren (ゼファレン) S/S TEE -VISIONARY- DARK.GREEN
26798 Zephyren (ゼファレン) VNECK S/S -BEYOND- WHITE
26799 Zephyren (ゼファレン) VNECK S/S -BEYOND- BLACKxWHITE
26802 Zephyren (ゼファレン) VNECK S/S -BEYOND- CHARCOAL
27485 Zephyren (ゼファレン) TIE DYE TRIBAL VNECK TEE BLACK
27486 Zephyren (ゼファレン) TIE DYE TRIBAL VNECK TEE RED
27496 Zephyren (ゼファレン) LONG S/S TEE -Ace of spades- Blue
27498 Zephyren (ゼファレン) PAISLEY POCKET VNECK WHT/BLK
27499 Zephyren (ゼファレン) PAISLEY POCKET VNECK BLK/WHT
28233 Zephyren (ゼファレン) IKExZephyren S/S TEE
30388 Zephyren(ゼファレン) BIG S/S TEE -CocaCola- WHITE
30446 Zephyren(ゼファレン) PONCHO TEE S/S WHITE
30447 Zephyren(ゼファレン) PONCHO TEE S/S BLACK
30448 Zephyren(ゼファレン) PONCHO TEE S/S PAISLEY
30454 Zephyren(ゼファレン) SWITCHING LONG S/S TEE BLACK
30474 Zephyren(ゼファレン) BIG VNECK S/S TEE HEX
30475 Zephyren(ゼファレン) BIG VNECK S/S TEE X-RAYSKULL
30477 Zephyren(ゼファレン) BIG S/S TEE HEX
30483 Zephyren(ゼファレン) CLASH BIG S/S TEE BLACK
30539 Zephyren(ゼファレン) S/S TEE -BEYOND- BLACKxBLACK
30546 Zephyren(ゼファレン) S/S TEE -REBEL FLAG- BLACKxGREEN
30561 Zephyren(ゼファレン) S/S TEE -ENGRAVE- WHITE
30562 Zephyren(ゼファレン) S/S TEE -ENGRAVE- BLACKxWHITE
30563 Zephyren(ゼファレン) S/S TEE -ENGRAVE- BLACKxRED
30567 Zephyren(ゼファレン) S/S TEE -BEYOND FLAME- WHITE
30568 Zephyren(ゼファレン) S/S TEE -BEYOND FLAME- BLACKxWHITE
30571 Zephyren(ゼファレン) S/S TEE -BEYOND FLAME- BURGUNDY
30573 Zephyren(ゼファレン) S/S TEE -SPADE FLAME- WHITE
30574 Zephyren(ゼファレン) S/S TEE -SPADE FLAME- BLACKxWHITE
30575 Zephyren(ゼファレン) S/S TEE -SPADE FLAME- BLACKxRED
30586 Zephyren(ゼファレン) S/S TEE -WEST RIDE- BLACKxWHITE
30594 Zephyren(ゼファレン) POCKET VNECK S/S WHITExBLACKPAISLEY
30595 Zephyren(ゼファレン) POCKET VNECK S/S BLACKxBLACKPAISLEY
30599 Zephyren(ゼファレン) STAR STUDS VNECK S/S BLACKxSILVER
30602 Zephyren(ゼファレン) STAR STUDS VNECK S/S NAVYxSILVER
30616 Zephyren(ゼファレン) BIG S/S TEE -BEYOND- BLACK
30619 Zephyren(ゼファレン) BIG S/S TEE -SPADE FLAME- WHITE
30620 Zephyren(ゼファレン) BIG S/S TEE -SPADE FLAME- BLACK
30626 Zephyren(ゼファレン) STAR STUDS BIG S/S TEE BLACKxBLACK
30651 Zephyren(ゼファレン) TIE DYE S/S TEE -BEYOND- BLACK
30652 Zephyren(ゼファレン) TIE DYE S/S TEE -BEYOND- NAVY
30655 Zephyren(ゼファレン) TIE DYE S/S TEE -REBEL FLAG- BLACK
30656 Zephyren(ゼファレン) TIE DYE S/S TEE -REBEL FLAG- NAVY
32221 Zephyren (ゼファレン) S/S TEE -CHOCO BEYOND- BLACK
32222 Zephyren (ゼファレン) S/S TEE -CHOCO BEYOND- WHITE
32223 Zephyren (ゼファレン) S/S TEE -CHOCO BEYOND- BROWN
33081 Zephyren (ゼファレン) BIG S/S TEE -CocaCola- BLACK-CREW
33089 Zephyren (ゼファレン) BORDER S/S TEE -Cut the world- BLACKxCHARCOAL
33090 Zephyren (ゼファレン) BORDER S/S TEE -Cut the world- BLACKxRED
33092 Zephyren (ゼファレン) S/S TEE -Over the line- WHITE-VNECK
33093 Zephyren (ゼファレン) S/S TEE -Over the line- BLACK-VNECK
33094 Zephyren (ゼファレン) S/S TEE -Over the line- WHITE-CREW
33095 Zephyren (ゼファレン) S/S TEE -Over the line- BLACK-CREW
33122 Zephyren (ゼファレン) STAR STUDS VNECK S/S TEE WHITExBLACK
33129 Zephyren (ゼファレン) S/S TEE -CULT RIDE- WHITE
33133 Zephyren (ゼファレン) FOOT BALL S/S TEE -ENGRAVE- WHITExBLACK
33134 Zephyren (ゼファレン) FOOT BALL S/S TEE -ENGRAVE- BLACKxWHITE
33137 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- WHITE
33138 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- BLACKxWHITE
33142 Zephyren (ゼファレン) BIG S/S TEE -Cut the world- WHITE
33143 Zephyren (ゼファレン) BIG S/S TEE -Cut the world- BLACK
33148 Zephyren (ゼファレン) LONG S/S TEE -BEYOND- BLACKxBLACK
33151 Zephyren (ゼファレン) LONG S/S TEE -Hope- BLACK
33168 Zephyren (ゼファレン) S/S TEE -PORTAL- BLACKxWHITE
33171 Zephyren (ゼファレン) S/S TEE -PORTAL- GRAY
33177 Zephyren (ゼファレン) PAISLEY POCKET VNECK S/S WHITE
33178 Zephyren (ゼファレン) PAISLEY POCKET VNECK S/S BLACK
33181 Zephyren (ゼファレン) CREW NECK S/S TEE -MOON- WHITE
33182 Zephyren (ゼファレン) CREW NECK S/S TEE -MOON- BLACKxWHITE
33186 Zephyren (ゼファレン) TIE DYE S/S TEE -ENGRAVE- BLACK
33187 Zephyren (ゼファレン) TIE DYE S/S TEE -ENGRAVE- NAVY
33190 Zephyren (ゼファレン) TIE DYE S/S TEE -MOON- BLACK
33191 Zephyren (ゼファレン) TIE DYE S/S TEE -MOON- NAVY
33196 Zephyren (ゼファレン) EKG TIE DYE S/S TEE -BEYOND- BLUE
33500 Zephyren (ゼファレン) SWITCHING S/S TEE WHITE
33501 Zephyren (ゼファレン) SWITCHING S/S TEE BLACK
33502 Zephyren (ゼファレン) SWITCHING S/S TEE BLACK-BORDER
33503 Zephyren (ゼファレン) SWITCHING S/S TEE BURGUNDY-BORDER
34062 Zephyren(ゼファレン) S/S TEE -glassy girl- WHITE
34063 Zephyren(ゼファレン) S/S TEE -glassy girl- BLACK×COLOR
34068 Zephyren(ゼファレン) S/S TEE -melt hand- WHITE
34069 Zephyren(ゼファレン) S/S TEE -melt hand- BLACK×WHITE
34070 Zephyren(ゼファレン) S/S TEE -melt hand- BLACK×RED
34071 Zephyren(ゼファレン) S/S TEE -melt hand- BURGUNDY
34931 Zephyren (ゼファレン) S/S TEE -THORN CROSS- WHITE
34932 Zephyren (ゼファレン) S/S TEE -THORN CROSS- BLACKxWHITE
34933 Zephyren (ゼファレン) S/S TEE -THORN CROSS- BLACKxTURQUOISE
34934 Zephyren (ゼファレン) S/S TEE -THORN CROSS- BLUExYELLOW
35372 Zephyren (ゼファレン) S/S TEE -BEYOND- PURPLE
35375 Zephyren (ゼファレン) S/S TEE -Inhale the black- WHITExBLACK
35376 Zephyren (ゼファレン) S/S TEE -Inhale the black- BLACKxBLACK
35377 Zephyren (ゼファレン) S/S TEE -PORTAL- WHTIE
35381 Zephyren (ゼファレン) S/S TEE -PORTAL- BLACKxLUMINOUS
35393 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- BLACKxRED
35394 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- GRAY
35527 Zephyren (ゼファレン) S/S TEE -Inhale the black- BLACKxNAVY
35771 Zephyren (ゼファレン) CRASHED PAINT S/S VNECK WHITE
35772 Zephyren (ゼファレン) CRASHED PAINT S/S VNECK BLACK.DENIM
35773 Zephyren (ゼファレン) CRASHED PAINT S/S VNECK INDIGO.DENIM
35819 Zephyren (ゼファレン) PONCHO TEE L/S PAISLEY
36092 Zephyren (ゼファレン) CRASHED PAINT S/S VNECK WHITE
36093 Zephyren (ゼファレン) CRASHED PAINT S/S VNECK BLACK.DENIM
36094 Zephyren(ゼファレン) STAR STUDS VNECK S/S BLACKxBLACK
36601 Zephyren (ゼファレン) S/S TEE -A day with a Coke- WHT
36602 Zephyren (ゼファレン) S/S TEE -A day with a Coke- BLK
36603 Zephyren (ゼファレン) S/S TEE -A day with a Coke- RED
36604 Zephyren (ゼファレン) S/S TEE -Vivid Coke- WHT
36605 Zephyren (ゼファレン) S/S TEE -Vivid Coke- BLK
36606 Zephyren (ゼファレン) S/S TEE -Vivid Coke- RED
38327 Zephyren (ゼファレン) LONG TAPE BIG TEE S/S BLACKxWHITE
38383 Zephyren (ゼファレン) BANDANA S/S TEE -TRUST- WHITE
38384 Zephyren (ゼファレン) BANDANA S/S TEE -TRUST- BLACKxNAVY
38406 Zephyren (ゼファレン) S/S TEE -REVIVE- WHITExCOLOR
38413 Zephyren (ゼファレン) BIG S/S TEE -PLEDGE- BLACK
38920 Zephyren(ゼファレン) Zephyren ゼファレン S/S TEE -Coke Memory- BLK
38921 Zephyren(ゼファレン) Zephyren ゼファレン S/S TEE -Coke Memory- WHT
40049 Zephyren PONCHO TEE S/S LETTER
40059 Zephyren SWITCHING S/S TEE WHITE
40060 Zephyren SWITCHING S/S TEE BLACK
40086 Zephyren S/S TEE -BEYOND SPLASH- WHITE
40087 Zephyren S/S TEE -BEYOND SPLASH- BLACK
40094 Zephyren S/S TEE -PLEDGE- BLACK
40135 Zephyren BIG S/S TEE -TRAIL- WHITE
40136 Zephyren BIG S/S TEE -TRAIL- BLACK
40141 Zephyren FOOTBALL S/S TEE -TRAIL- BLACKxWHITE
40144 Zephyren BIG S/S TEE -SEAMLESS- BLACK
40853 Zephyren MY FIRST STORY x A.V.E.S.T S/S TEE BLACK
40854 Zephyren ヒステリックパニック x A.V.E.S.T S/S TEE BLACK
40855 Zephyren a crowd of rebellion x A.V.E.S.T S/S TEE BLACK
40856 Zephyren バンドじゃないもん x A.V.E.S.T S/S TEE BLACK
40857 Zephyren PassCode x A.V.E.S.T S/S TEE BLACK
41082 ZEPHYREN (ゼファレン) S/S TEE -VISIONARY- PINK
42100 Zephyren(ゼファレン) S/S TEE -BEYOND- PINK
42111 Zephyren(ゼファレン) S/S TEE -DOOR- WHITE