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 12:56:20')
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 240, 120
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
18715 NineMicrophones STADIUM JACKET -9MC Crew- BLK
18717 NineMicrophones PARKA -RUN 9MC- BLACK
18720 NineMicrophones PARKA -9MC ASSOCIATION- BLACK
18726 NineMicrophones ZIP PARKA -9MC Crew- GRAY
18727 NineMicrophones ZIP PARKA -9MC Crew- - NAVY
18728 NineMicrophones ZIP PARKA -Comrade- - BLACK
18730 NineMicrophones ZIP PARKA -Comrade- - NAVY
18732 NineMicrophones 9MC Loco PARKA NAVY
18733 NineMicrophones 9MC Loco PARKA GRAY
18736 NineMicrophones WORK SHIRT L/S -eve WHT
18737 NineMicrophones WORK SHIRT L/S -eve BLK
18739 NineMicrophones CHECK SHIRTL/S -Comrade- BLACK
18750 NineMicrophones BASEBALL SHIRT -Comrade- - BLACK
18752 NineMicrophones BASEBALL SHIRT -Comrade- - NAVY
18765 NineMicrophones 9MICS Crew S/S - BLACK-BURGUNDY
18767 NineMicrophones bronx S/S - WHITE
18770 NineMicrophones bronx S/S - GRAY
18773 NineMicrophones Comrade R-7/S - WHITE- BLACK
18775 NineMicrophones WORK PANTS-RADICAL ROUTINE- BLK
18776 NineMicrophones WORK PANTS-RADICAL ROUTINE-CHA
18780 NineMicrophones DENIM-Eternal- - INDIGO-HARD_WASH
18798 NineMicrophones MESH CAP-~9MC Loco~- BLACK/WHITE
18799 NineMicrophones MESH CAP-~9MC Loco~- BLK/BGN
18800 NineMicrophones MESH CAP-~9MC Loco~- - BLACK-GOLD
18801 NineMicrophones BEANIE -Power of will- BLACK
18802 NineMicrophones BEANIE -Power of will- BURGUNDY
18804 NineMicrophones WATCH CAP -Higher than the BLK
18805 NineMicrophones WATCH CAP -Higher than the RED
18806 NineMicrophones WATCH CAP -Higher than the BLUE
18807 NineMicrophones BUCKET HAT -9MC ASSOCIATION- - WHT
18808 NineMicrophones BUCKET HAT -9MC ASSOCIATION- - BLK
18809 NineMicrophones BUCKET HAT -9MC ASSOCIATI
18810 NineMicrophones FELT HAT -Sinner- BLACK
18811 NineMicrophones METAL NECKLACE-Pray- BLK
18812 NineMicrophones METAL NECKLACE-Pray- A.SIL
18814 NineMicrophones METAL NECKLACE-TATTOO MACHINE BLK
18815 NineMicrophones METAL NECKLACE-TATTOOMACHINE-A.SIL
18816 NineMicrophones METAL NECKLACE-TATTOOMACHINE-A.GLD
18817 NineMicrophones DOG TAG -9MC Crew- - SILVER
20025 NineMicrophones SWEAT PANTS-Deff posse- BLACK
20957 NineMicrophones ZIP PARKA -9MC Crew- WHITE
20963 NineMicrophones CHECK SHIRT L/S-Pray with the microphone- BLACK
20964 NineMicrophones CHECK SHIRT L/S-Pray with the microphone- YELLOW
20969 NineMicrophones (ナイン・マイクロフォンズ) B.D.U L/S-Judgement- BLACK
20970 NineMicrophones (ナイン・マイクロフォンズ) B.D.U L/S-Judgement- KHAKI
20973 NineMicrophones (ナイン・マイクロフォンズ) SLEEVE BORDER SHIRT BLK/WHT
20980 NineMicrophones (ナイン・マイクロフォンズ) BOWLING SHIRT S/S-MORTOR HEAD- MUSTARD
20994 NineMicrophones 9MICS CREW S/S BLU-MUS
20995 NineMicrophones (ナイン・マイクロフォンズ) Pray with the microphone S/S WHITE
20996 NineMicrophones (ナイン・マイクロフォンズ) Pray with the microphone S/S BLK/WHT
20997 NineMicrophones Do or Die S/S WHITE
20998 NineMicrophones Do or Die S/S BLK-BGN
20999 NineMicrophones Do or Die S/S CHARCOAL
21000 NineMicrophones Sun forever S/S WHITE
21001 NineMicrophones Sun forever S/S BLACK
21003 NineMicrophones Joy ride S/S BLACK
21006 NineMicrophones ANNOMARY S/S BLACK
21016 NineMicrophones DENIM-Punk skaters- BLACKII
21024 NineMicrophones (ナイン・マイクロフォンズ) SNAP BACK CAP-FIGHT BLK
21025 NineMicrophones (ナイン・マイクロフォンズ) SNAP BACK CAP-FIGHT BLK/GRY