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 08:44:35')
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 225, 75
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