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-24 08:12:21')
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
LIMIT 0, 120
2444 NineMicrophones MESH CAP Deck-9- BLACK
3187 NineMicrophones WALLET CHAIN -9MC Crew- BLK/WHT
3555 Nine Microphones Pray with the microphone R-S/S BK
4227 Nine Microphones MAD SKULL S/S BK/WH
4406 Nine Microphones LEATHER BELT -Punk Skater-WH/BK
4407 NineMicrophones LEATHER BELT -Punk Skater-BK/WH
5934 NineMicrophones 9MC Loco PARKA BLK/WHT
6295 NineMicrophones WALLET CHAIN -9MC Crew- BLK/BGN
6297 NineMicrophones WALLET CHAIN -9MC Crew- BGN/MUS
6470 NineMicrophones G.I BELT Black
6471 NineMicrophones G.I BELT Blue
6472 NineMicrophones G.I BELT Beige
6473 NineMicrophones G.I BELT Khaki
7801 Nine Microphones CHECK SHIRT S/S-Blood Sympathy-RD
8299 Nine Microphones Pray with the microphone S/S NAVY
8306 Nine Microphones The angel soare S/S BLK
8307 Nine Microphones The angel soare S/S NAVY
8309 Nine Microphones The angel soare S/S GRAY
8311 Nine Microphones bronx S/S BLACK/BURGUNDY
8312 NineMicrophones bronx S/S BLACK/WHITE
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-