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-04-28 20:58:14')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 250)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 400, 100
25968 NineMicrophones MA-1-Strum your mind- BLACK
25977 NineMicrophones (ナインマイクロフォンズ) Light ZIP PARKA-Fight back- BLACK
25978 NineMicrophones (ナインマイクロフォンズ) Light ZIP PARKA-Fight back- GRAY
25983 NineMicrophones ZIP PARKA -9MC Crew- GREEN
25990 NineMicrophones (ナインマイクロフォンズ) ZIP PARKA-Break your deck- BLACK
25991 NineMicrophones ZIP PARKA-Break your deck- GRAY
25992 NineMicrophones (ナインマイクロフォンズ) LINE PARKA-Skate College- WHITE
25993 NineMicrophones (ナインマイクロフォンズ) LINE PARKA-Skate College- BLACK
25995 NineMicrophones (ナインマイクロフォンズ) SWEAT-CAMOUFLAGE 9MC Crew- WHITE
25996 NineMicrophones (ナインマイクロフォンズ) SWEAT-CAMOUFLAGE 9MC Crew- BLACK
26003 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- BLACK
26004 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- RED
26007 NineMicrophones CHECK SHIRT L/S-9MC Crew- RED
26008 NineMicrophones CHECK SHIRT L/S-9MC Crew- GREEN
26012 NineMicrophones CAMOUFLAGE SHIRT-Strum your mind- BLACK
26013 NineMicrophones CAMOUFLAGE SHIRT-Strum your mind- KHAKI
26020 NineMicrophones WORK SHIRT-Trust your own judgement- BURGUNDY
26021 NineMicrophones DENIM SHIRT L/S-Pray with the microphones- INDIGO
26022 NineMicrophones DENIM SHIRT L/S-Pray with the microphones- BLK
26024 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone S/S WHT/WHT
26026 NineMicrophones Pray with the microphone S/S BLK/BLK
26032 NineMicrophones Power Of Will S/S WHT-BLK
26038 NineMicrophones (ナインマイクロフォンズ) 9MICS Crew S/S WHT/BGN
26040 NineMicrophones (ナインマイクロフォンズ) 9MICS Crew S/S RED/WHT
26057 NineMicrophones 9MICS Crew L/S BLK-BGN
26063 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone L/S WHT-BLK
26065 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone L/S BLK-WHT
26072 NineMicrophones (ナインマイクロフォンズ) Ta2 the world S/S WHT/BLK
26074 NineMicrophones (ナインマイクロフォンズ) Ta2 the world S/S BLK/WHT
26076 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S WHT/BLK
26077 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S WHT/BGN
26078 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S BLK/WHT
26079 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S BLK/BGN
26080 NineMicrophones (ナインマイクロフォンズ) Strum your mind S/S WHITE
26081 NineMicrophones (ナインマイクロフォンズ) Strum your mind S/S BLACK
26085 NineMicrophones (ナインマイクロフォンズ) Lone wolf S/S BLACK
26090 NineMicrophones EMBROIDERY WORK PANTS-Pray with the microphone- BLACK
26091 NineMicrophones EMBROIDERY WORK PANTS-Pray with the microphone- BEIGE
26093 NineMicrophones DENIM-Eternal- IND-O.W
26096 NineMicrophones DENIM-Eternal- BLK-H.W
26101 NineMicrophones MESH CAP-~9MC Loco~- DENIM
26102 NineMicrophones SNAP BACK CAP-Strum your mind- WHT
26103 NineMicrophones SNAP BACK CAP-Strum your mind- BLK
26104 NineMicrophones SNAP BACK CAP-Strum your mind- BLU
26105 NineMicrophones SNAP BACK CAP-Strum your mind- BLK-YEL
26108 NineMicrophones (ナインマイクロフォンズ) BUCKET HAT-9MC Crew- CAMOUFLAGE
26109 NineMicrophones CAMOUFLAGE SNAPBACK CAP-bronx- KHA-GLD
26111 NineMicrophones BEANIE-Bronx- BLK
26112 NineMicrophones BEANIE-Bronx- MUS
26113 NineMicrophones BEANIE-Bronx- GRN
26114 NineMicrophones BEANIE-9MC Crew- BLK
26115 NineMicrophones BEANIE-9MC Crew- BGN
26116 NineMicrophones BEANIE-9MC Crew- NVY
26117 NineMicrophones FELT HAT-Comrade- BLK
26118 NineMicrophones FELT HAT-Comrade- BRW
28251 NineMicrophones (ナインマイクロフォンズ) POCKET S/S TEE
29388 NineMicrophones (ナインマイクロフォンズ) Packable ANORAK-F.O.B- RED
29389 NineMicrophones (ナインマイクロフォンズ) Packable ANORAK-F.O.B- BLUE
29390 NineMicrophones (ナインマイクロフォンズ) WORK JACKET-Love and Sacrifice- BLACK
29392 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- BLACK
29393 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- GRAY
29394 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- BURGUNDY
29395 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- WHITE
29396 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- BLACK
29397 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- GRAY
29398 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- WHITE
29399 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- BLACK-WHITE
29400 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- BLACK-BURGUNDY
29401 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- GRAY
29402 NineMicrophones (ナインマイクロフォンズ) SWEAT -Lightning- WHITE
29403 NineMicrophones (ナインマイクロフォンズ) SWEAT -Lightning- BLACK
29404 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLACK
29405 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLUE
29406 NineMicrophones (ナインマイクロフォンズ) OXFORD SHIRT L/S-Sunny- WHITE
29407 NineMicrophones (ナインマイクロフォンズ) OXFORD SHIRT L/S-Sunny- BLACK
29410 NineMicrophones (ナインマイクロフォンズ) FOOTBALL SHIRT-9MC Crew- BLACK
29411 NineMicrophones (ナインマイクロフォンズ) FOOTBALL SHIRT-9MC Crew- NAVY
29412 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLACK
29413 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLUE
29416 NineMicrophones (ナインマイクロフォンズ) Play with the microphone L/S WHITE
29417 NineMicrophones (ナインマイクロフォンズ) Play with the microphone L/S BLACK
29418 NineMicrophones (ナインマイクロフォンズ) Honor L/S WHITE
29419 NineMicrophones (ナインマイクロフォンズ) Honor L/S BLACK
29421 NineMicrophones (ナインマイクロフォンズ) Honor S/S WHITE
29422 NineMicrophones (ナインマイクロフォンズ) Honor S/S BLACK
29424 NineMicrophones (ナインマイクロフォンズ) Pass the mic S/S WHITE
29425 NineMicrophones (ナインマイクロフォンズ) Pass the mic S/S BLACK
29431 NineMicrophones (ナインマイクロフォンズ) 9MICS Crew S/S WHITE-RED
29441 NineMicrophones (ナインマイクロフォンズ) VNECK S/S -Lightning- BLACK
29450 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- WHITE
29451 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- BLACK
29453 NineMicrophones (ナインマイクロフォンズ) WORK PANTS-RADICAL ROUTINE- BEIGE
29467 NineMicrophones (ナインマイクロフォンズ) CHAMBLEY SNAP BACK CAP-Lightning- BLACK
29469 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT BLACK
29470 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT CAMEL
29481 NineMicrophones (ナインマイクロフォンズ) iphone6,7 case-Back stage- BLACK
32095 NineMicrophones SNAP BACK CAP -Comrade- BLACK/YELLOW
32096 NineMicrophones SNAP BACK CAP -Comrade- WHITE/BLACK
32097 NineMicrophones SNAP BACK CAP -Comrade- BLACK/WHITE
32928 NineMicrophones ALOHA SHIRT-Pizzalia- WHITE