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-03-29 10:45:54')
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 120, 120
8321 NineMicrophones WALLET CHAIN -9MC Crew- BLU/BLK
8322 NineMicrophones KEY HOLDER -9MC Crew- BRG/MUSTARD
8323 NineMicrophones KEY HOLDER -9MC Crew- BLU/BLK
8384 Nine Microphones Spoiled a Dog S/S WHITE
8443 Nine Microphones Pray with the microphone 7/S NAVY
8444 Nine Microphones 9MC Crew 7/S NAVY
8446 Nine Microphones The angel soare L/S BLK/BRG
8452 NineMicrophones 9MC Loco PARKA BLK/BRG
8879 Nine Microphones DENIM -Rock studs 2- IN/SIL/ONE
9235 Nine Microphones MESH CAP -Power of will- D.GREEN
10462 Nine Microphones BATTALION JKT -MAD SKULL- BLACK
10523 NineMicrophones (ナインマイクロフォンズ) DENIM -Punk skeaters- INDIGO
10525 Nine Microphones TEAM JKT -MAD SKULL- BLACK
10627 Nine Microphones The angel soare L/S WHT/COLOR
10874 Nine Microphones The angel soare S/S White
10875 Nine Microphones The angel soare S/S Black
11229 Nine Microphones HEAVEN S/S Gray
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
11289 Nine Microphones FATAL S/S BLACK
11502 NineMicrophones SHOUT SKULL S/S BLACK/MUSTARD
11503 NineMicrophones SHOUT SKULL S/S NAVY/MUSTARD
11554 NineMicrophones WORK SHORTS EMBROIDRY-9MC- BLK/W
11780 NineMicrophones STUDS DECK JKT Comrade BLACK 14SP
11888 NineMicrophones POLO S/S -9MC Crew- BLACK/WHITE
11958 NineMicrophones WORK SHIRT S/S -Power- MAS
12335 NineMicrophones STUDS SHIRT S/S -Comrade- IND/DENI
12336 NineMicrophones STUDS SHIRT S/S -Comrade-BLK/DENI
12338 NineMicrophones 9MC SK8 PATTERNED TANK TOP WHITE
12339 NineMicrophones 9MC SK8 PATTERNED TANK TOP BLUE
12345 NineMicrophones 9MC SK8 PATTERNED VNECK S/S BLUE
12436 NineMicrophones GAME SHIRT Ⅱ -9MC Crew-BLACK/GRAY
12437 NineMicrophones PAISLEY SHIRT S/S -Power-WHITE
12438 NineMicrophones PAISLEY SHIRT S/S -Power-BEIGE
12439 NineMicrophones PAISLEY SHIRT S/S -Power-GREEN
12440 NineMicrophones PAISLEY SHIRT S/S -Power-BLACK
12442 NineMicrophones STRIPE SHIRT S/S -bronx-BLACK
12443 NineMicrophones STRIPE SHIRT S/S -bronx-WHITE
12446 NineMicrophones GAME SHORTS -9MC Crew-BLACK/RED
12448 NineMicrophones MUD SKULL S/S BLACK
12449 NineMicrophones MUD SKULL S/S DENIM
12453 NineMicrophones Arms No Fear S/S CHARCOAL
12456 NineMicrophones TATTO PRAYING HANDS S/S BLACK/BGN
12467 NineMicrophones PATCHWORK SHIRT S/S -FIGHT- BLACK
12470 NineMicrophones PATCHWORK SHIRT S/S -FIGHT-GRAY
12504 NineMicrophones GAME SHIRT -SHOUT SKULL-BGN
12507 NineMicrophones Attitude of Faith S/S BLACK
12508 NineMicrophones Attitude of Faith S/S WHITE
12679 NineMicrophones WHAT I GOT S/S WHITE/BGN
12680 NineMicrophones WHAT I GOT S/S BLACK/BGN
12684 NineMicrophones Mind of cupid S/S BLACK/BGN
12688 NineMicrophones Capricorn S/S BLACK/BROWN
12689 NineMicrophones Capricorn S/S WHITE/BROWN
12690 NineMicrophones Capricorn S/S BLACK/BGN
13522 NineMicrophones TANK TOP-9MC Crew- BLACK/WHITE
13523 NineMicrophones TANK TOP-9MC Crew- BLACK/BGN
13524 NineMicrophones TANK TOP -9MC Crew- WHITE
13525 NineMicrophones TANK TOP-9MC Crew- GRAY
13528 NineMicrophones Power of will S/S WHITE
13529 NineMicrophones Power of will S/S BLACK/WHITE
13530 NineMicrophones Power of will S/S BLACK/BGN
13531 NineMicrophones Power of will S/S GRAY
13532 NineMicrophones Power of will S/S BGN
13533 NineMicrophones Power of will S/S NAVY
13706 NineMicrophones Power of will R-7/S WHITE/BLACK
13708 NineMicrophones Power of will R-L/S GRAY/NAVY
13709 NineMicrophones COACH JKT -9MC Crew- BLACK/WHITE
13712 NineMicrophones ZIP PARKA -TATTOO MACHINE-BLK/WHT
13727 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/WHT
13728 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/BGN
13729 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-CGY
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