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-26 23:12:13')
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 360, 120
21026 NineMicrophones (ナイン・マイクロフォンズ) SNAP BACK CAP-FIGHT BACK- BLK-RED
21027 NineMicrophones (ナイン・マイクロフォンズ) SNAP BACK CAP-FIGHT BACK- BLK/YEL
23476 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/WHITE
23477 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/BURGUNDY
23479 NineMicrophones WORK SHIRT S/S-The 9- WHITE
23480 NineMicrophones WORK SHIRT S/S-The 9- BLACK
23481 NineMicrophones WORK SHIRT S/S-The 9- - BLUE
23487 NineMicrophones CHECK SHIRT S/S-Comrade- - BLACK
23488 NineMicrophones CHECK SHIRT S/S-Comrade- - RED
23489 NineMicrophones CHECK SHIRT S/S-Comrade- - BLUE
23498 NineMicrophones 9MC Crew S/S-CAMOUFLAGE- WHITE
23499 NineMicrophones 9MC Crew S/S-CAMOUFLAGE- BLACK
23500 NineMicrophones The game of life S/S - WHITE
23501 NineMicrophones The game of life S/S - BLACK/WHITE
23511 NineMicrophones Sun forever S/S - BURGUNDY
23525 NineMicrophones 9MICS Crew S/S - WHITE/S BLUE
23526 NineMicrophones 9MICS Crew S/S - GREEN/YELLOW
23537 NineMicrophones Power Of Will S/S - NAVY/MUSTARD
23554 NineMicrophones ALOHA SHORTS - BLACK
23562 NineMicrophones SNAP BACK CAP-LOCAL AREA- BLACK
23563 NineMicrophones SNAP BACK CAP-LOCAL AREA- BLK/GRY
23564 NineMicrophones SNAP BACK CAP-LOCAL AREA- BLK/RED
23570 NineMicrophones MESH CAP-Deck 9- BLACK/RED
23572 NineMicrophones BUCKET HAT-9MC Crew- - WHITE
23573 NineMicrophones BUCKET HAT-9MC Crew- - BLACK
23574 NineMicrophones BUCKET HAT-9MC Crew- DENIM
23578 NineMicrophones STRAW HAT - BLACK
23587 NineMicrophones BANDANNA-I'll stand by you- BLACK
23588 NineMicrophones BANDANNA-I'll stand by you- NAVY
25329 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone S/S BLACK/MUSTARD
25943 NineMicrophones STADIUM JACKET-Strum your mind- WHITE
25944 NineMicrophones STADIUM JACKET-Strum your mind- BLACK
25945 NineMicrophones METAL NECKLACE-9- SILVER
25946 NineMicrophones METAL NECKLACE-9- ANTIQUE SILVER
25947 NineMicrophones METAL NECKLACE-9- ANTIQUE GOLD
25948 NineMicrophones METAL NECKLACE-9- BRONDS
25951 NineMicrophones COACH JACKET-Pray with the microphone- BLACK/WHITE
25952 NineMicrophones COACH JACKET-Pray with the microphone- WHITE/BLACK
25953 NineMicrophones COACH JACKET-Pray with the microphone- BURGUNDY
25954 NineMicrophones COACH JACKET-Pray with the microphone- CHARCOAL
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