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:49:38')
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 200, 100
13730 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-NAVY
13736 NineMicrophones ZIP PARKA -9MC Crew- BLK/BGN
13737 NineMicrophones ZIP PARKA -9MC Crew- NAVY
13739 NineMicrophones ZIP PARKA -9MC Crew- BLK/WHT
13797 NineMicrophones BORDER TEE S/S -9MC Crew- RED
14074 NineMicrophones STUDS SHIRTS L/S -Comrade- BLK
14075 NineMicrophones STUDS SHIRTS L/S -Comrade- BLK/DE
14076 NineMicrophones STUDS SHIRTS L/S -Comrade- IDG/DEN
14077 NineMicrophones TEAM JKT -FIGHT BACK-KHAKI
14078 NineMicrophones TEAM JKT -FIGHT BACK- BLK/BUR
14080 NineMicrophones TEAM JKT -Power of will- NAVY
14239 NineMicrophones CHECK HOODY SHIRTS-Comrade- NAVY
14241 NineMicrophones CHECK HOODY SHIRTS-Comrade-MUSTARD
14243 NineMicrophones PATCHWORK SHIRTS-FIGHT BACK- BLUE
14244 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/BGD
14245 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/WHT
14246 NineMicrophones PATCHWORK SHIRTS -FIGHT BACK- GRAY
14351 NineMicrophones STUDS DECK JKT -Comrade- KHAKI
14352 NineMicrophones STUDS DECK JKT -Comrade- BLK/DENIM
14353 NineMicrophones STUDS DECK JKT -Comrade- INDIGO
14504 NineMicrophones WORK JKT -SHOUT SKULL- CAMOUFLAGE
14505 NineMicrophones WORK JKT -SHOUT SKULL- BLACK
14510 NineMicrophones 9MC SK8 PATTERNED MOUNTAIN BLUE
14512 NineMicrophones 9MC SK8 PATTERNED MOUNTAIN WHITE
14649 NineMicrophones PATCHWORK SWEATER BLACK/BURGUNDY
14651 NineMicrophones PATCHWORK SWEATER NAVY
14741 NineMicrophones 9MC Loco PARKA NAVY
14742 NineMicrophones 9MC Loco PARKA CHACOAL
14957 NineMicrophones PHARAOH JKT -Proposition Nine-
15111 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA BLK
15112 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA WHITE
15113 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA NAVY
15114 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA BUR
15115 NineMicrophones LINING CAMO CARDIGAN Black/white
15117 NineMicrophones LINING CAMO CARDIGAN KHAKI
15786 NineMicrophones ZIP PARKA-King Of The Road- BLK/RE
15792 NineMicrophones ZIP PARKA-King Of The Road- BLK/WH
15794 NineMicrophones King Of The Road L/S BLK/RED
15795 NineMicrophones King Of The Road L/S BLK/WHI
15896 Nine Microphones 9MC Loco PARKA CHARCOAL GRAY
15903 NineMicrophones King Of The Road 7/S BLK/WHI
15904 NineMicrophones King Of The Road 7/S BLK/BGN
15905 NineMicrophones King Of The Road 7/S BLK/WHI
15907 NineMicrophones King Of The Road R-7/S WHI/BLK
15908 NineMicrophones King Of The Road R-7/S GRY/BLK
15990 NineMicrophones DECK JKT-FIGHT BACK- BLK/WHT
15991 NineMicrophones DECK JKT-FIGHT BACK- BEIGE CAMO
15992 NineMicrophones DECK JKT-FIGHT BACK- KHAKI CAMO
15993 NineMicrophones TEAM JKT-FIGHT BACK- BLK/WHT
15994 NineMicrophones TEAM JKT-FIGHT BACK- BLK/BUR
15995 NineMicrophones TEAM JKT-FIGHT BACK- BEIGE CAMO
15997 NineMicrophones SNAP BACK CAP-9MC Crew- BLK/WHT
15998 NineMicrophones SNAP BACK CAP-9MC Crew- BLK/BUR
16393 NineMicrophones GAME SHIRT-Sixth man- - BLACK
16394 NineMicrophones GAME SHIRT-Sixth man- RED
16396 NineMicrophones FOOTBALL TEE-King Of The Road- BLK
16397 NineMicrophones FOOTBALL TEE-King Of The Road- BGN
16399 NineMicrophones 9MC Crew S/S - BLACK/WHITE
16400 NineMicrophones 9MC Crew S/S - BLACK/BURGUNDY
16401 NineMicrophones 9MC Crew S/S - BURGUNDY
16410 NineMicrophones Strength and honor S/S - WHITE
16412 NineMicrophones Strength and honor S/S - BLK/ORG
16428 NineMicrophones TANK TOP-9MC Crew- - WHITE
16429 NineMicrophones TANK TOP-9MC Crew- - BLACK/WHITE
16430 NineMicrophones TANK TOP-9MC Crew BLACK/BURGUNDY
16438 NineMicrophones DENIM-Eternal- - INDIGO/NON WASH
16439 NineMicrophones DENIM-Eternal- - BLACK/NON WASH
16449 NineMicrophones WORK SHORTS-Comrade- BLACK
16450 NineMicrophones WORK SHORTS-Comrade- BEIGE
16451 NineMicrophones CARGO SHORTS BLK
16452 NineMicrophones SNAP BACK CAP~9MC Loco~BLACK/WHITE
16453 NineMicrophones SNAP BACK CAP-~9MC Loco~- NAVY
16454 NineMicrophones SNAP BACK CAP~9MC Loco~WHITE×BLACK
16458 NineMicrophones SNAP BACK CAP-9MC Crew- GRAY
16459 NineMicrophones SNAP BACK CAP-9MC Crew- BURGUNDY
16469 NineMicrophones SUMMER BEANIE NAVY
16491 NineMicrophones DENIM-Eternal- BLK/ONE
16493 NineMicrophones DENIM-Punk skaters- BLACK
16691 NineMicrophones ZIP PARKA-NINE BONES- BLK
16692 NineMicrophones ZIP PARKA-NINE BONES- GRAY
17380 NineMicrophones NINE BONES S/S WHITE
17381 NineMicrophones NINE BONES S/S BLACK
17383 NineMicrophones TANK TOP-NINE BONES-
17566 NineMicrophones CHECK L/S-King Of The Road- NAVY
17567 NineMicrophones CHECK L/S-King Of The Road-MUSTARD
17568 NineMicrophones CHECK L/S-King Of The Road- BGN
17569 NineMicrophones STRIPE SHIRT L/S-bronx- WHITE
17570 NineMicrophones STRIPE SHIRT L/S-bronx- NAVY
17571 NineMicrophones STRIPE SHIRT L/S-Power Of Will-WHT
17572 NineMicrophones STRIPE SHIRT L/S-Power Of Will-BLK
17574 NineMicrophones PAISLEY S/S-King Of The Road- WHT
17575 NineMicrophones PAISLEY S/S-King Of The Road- BGN
17576 NineMicrophones PAISLEY S/S-King Of The Road- BLK
17816 NineMicrophones King Of The Road S/S WHITE
17817 NineMicrophones King Of The Road S/S BLACK/WHITE
17820 NineMicrophones King Of The Road S/S BURGUNDY
17822 NineMicrophones King Of The Road S/S BLK/BURGUNDY
18700 NineMicrophones TEAM JACKET -Represent The BLK
18703 NineMicrophones LEATHER TRUCK JACKET feather BLK
18714 NineMicrophones STADIUM JACKET -9MC Crew- WHT