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 17:56:52')
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 600, 120
39711 NineMicrophones JERSEY SHIRT NAVY
39712 NineMicrophones CHECK GATHERD SHIRT RED
39713 NineMicrophones CHECK GATHERD SHIRT NAVY
39721 NineMicrophones PROMOTION WHITE
39722 NineMicrophones PROMOTION BLACK
39725 NineMicrophones FAINT WHITE
39726 NineMicrophones FAINT BLACK
39727 NineMicrophones STRONGER WHITE
39728 NineMicrophones STRONGER GRAY
39729 NineMicrophones CUT OFF-DTYW- WHITE
39730 NineMicrophones CUT OFF-DTYW- BLACK
39735 NineMicrophones Neo Punk Skaters BLACK
39736 NineMicrophones Neo Punk Skaters INDIGO
39742 NineMicrophones SNAPBACKCAP-Comrade- BLACK/BLACK
39743 NineMicrophones SNAP BACK CAP-9MC Crew- BLACK/WHITE
39744 NineMicrophones SNAP BACK CAP-9MC Crew- BLACK/BURGUNDY
39745 NineMicrophones PROMOTION CAP WHITE
39746 NineMicrophones PROMOTION CAP BLACK
39747 NineMicrophones PROMOTION CAP KHAKI
41497 NineMicrophones COACH JACKET-FAINT- WHITE
41498 NineMicrophones COACH JACKET-FAINT- BLACK
41499 NineMicrophones ZIP PARKA-Sing- GRAY
41500 NineMicrophones ZIP PARKA-Sing- BLACK
41503 NineMicrophones PARKA-FAINT- GRAY
41504 NineMicrophones PARKA-FAINT- BLACK
41505 NineMicrophones PARKA-Fellow- GRAY
41506 NineMicrophones PARKA-Fellow- BLACK
41507 NineMicrophones CARDIGAN BLACK
41508 NineMicrophones CARDIGAN BROWN
41511 NineMicrophones PROMOTION L/S WHITE
41512 NineMicrophones PROMOTION L/S BLACK
41513 NineMicrophones Sing L/S WHITE
41514 NineMicrophones Sing L/S BLACK
41526 NineMicrophones FELT CAP NAVY
41527 NineMicrophones KNIT CAP BLACK
41530 NineMicrophones BASQUE BERET BLACK
41531 NineMicrophones CARABINER-NM- WHITE
41532 NineMicrophones CARABINER-NM- BURGUNDY
41533 NineMicrophones CARABINER-NM- MULTI
41953 NineMicrophones PIGMENT FOOTBALL TEE YELLOW
41954 NineMicrophones PIGMENT FOOTBALL TEE GRAY
42994 NineMicrophones CHECK SHIRT RED
42995 NineMicrophones CHECK SHIRT NAVY
42996 NineMicrophones DENIM CAP GRAY
42997 NineMicrophones DENIM CAP BLACK
43447 NineMicrophones MOUNTAIN PARKA ORANGE
43799 NineMicrophones MOUNTAIN PARKA BLACK
43967 NineMicrophones Blood Sympathy R-7/S
43968 NineMicrophones Work Shirt L/S MAD SKULL
44913 NineMicrophones FELT CAP GRAY
45145 NineMicrophones COACH JACKET-STAY REAL- BLACK
45146 NineMicrophones COACH JACKET-STAY REAL- GREEN
45222 NineMicrophones ZIP PARKA-Way of Life- BLACK
45224 NineMicrophones ZIP PARKA-Way of Life- GRAY
45306 NineMicrophones PARKA-badge- WHITE
45307 NineMicrophones FRONT ZIP SWEAT-Comrade- BLACK
45308 NineMicrophones COACH JACKET-PROMOTION- BLACK
45309 NineMicrophones COACH JACKET-PROMOTION- IVORY
45310 NineMicrophones PARKA-badge- BLACK
45311 NineMicrophones FRONT ZIP SWEAT-Comrade- ORANGE
45553 NineMicrophones 9MC Crew-FRAMED-PARKA WHITE
45554 NineMicrophones 9MC Crew-FRAMED-PARKA BLACK
45555 NineMicrophones 9MC Crew-FRAMED-L/S WHITE
45556 NineMicrophones 9MC Crew-FRAMED-L/S BLACK
45557 NineMicrophones ORANGE COUNTY L/S WHITE
45558 NineMicrophones ORANGE COUNTY L/S BLACK
45697 NineMicrophones KNAPSACK-Comrade- WHITE
45698 NineMicrophones KNAPSACK-Comrade- BLACK
45727 NineMicrophones METAL NECKLACE-詩- ANTIQUE SILVER
45740 NineMicrophones Way of Life S/S BLACK
45741 NineMicrophones Way of Life S/S WHITE
45742 NineMicrophones STAY REAL S/S BLACK
45743 NineMicrophones STAY REAL S/S WHITE
46159 NineMicrophones LOW CAP-Comrade- NAVY
46160 NineMicrophones BIGTEE-Sing- BLACK
46878 NineMicrophones RAIN COAT BLACK
47472 NineMicrophones Board S/S BLACK
47473 NineMicrophones Board S/S WHITE
47474 NineMicrophones METAL NECKLACE-詩- ANTIQUE GOLD
47779 NineMicrophones MESH CAP-9mc~Loco~- WHITE
47780 NineMicrophones MESH CAP-9mc~Loco~- BLACK
47781 NineMicrophones MESH CAP-9mc~Loco~- BURGUNDY
47782 NineMicrophones FLAT BILL CAP-Comrade- BLACK
47783 NineMicrophones LOW CAP-93- BLACK
47784 NineMicrophones LOW CAP-93- GRAY
47830 NineMicrophones ""K""ABUKI-MONO S/S GRAY
47831 NineMicrophones ""K""ABUKI-MONO S/S WHITE
48362 NineMicrophones TANK TOP-FAINT- WHITE/BLACK
48363 NineMicrophones TANK TOP-FAINT- WHITE/BURGUNDY
48364 NineMicrophones TANK TOP-FAINT- BLACK
48539 NineMicrophones SKATE BAG BLACK
48597 NineMicrophones-GAME SHIRT-9MC Crew--BLACK/WHITE
48598 NineMicrophones GAME SHIRT-9MC Crew- BLACK/RED
48599 NineMicrophones GAME SHIRT-9MC Crew- NAVY
49915 NineMicrophones key holder WHITE/BLACK
49916 NineMicrophones key holder BLACK/WHITE
49917 NineMicrophones key holder MULTI
50423 NineMicrophones GUITAR BAG BLACK
50424 NineMicrophones PARKA-9MC LOCO- SILVER
50425 NineMicrophones PARKA-9MC LOCO- GOLD
50426 NineMicrophones ZIP PARKA-Text- BLACK/MUSTARD
50427 NineMicrophones ZIP PARKA-Text- GRAY
50675 NineMicrophones SOCKS-Name- WHITE
51064 NineMicrophones COACH JACKET-NEW MC CREW- BLACK
51072 NineMicrophones PARKA-Sun forever2020- BLACK
51073 NineMicrophones PARKA-Sun forever2020- GRAY
51074 NineMicrophones PARKA-Sun forever2020- BROWN
51091 NineMicrophones FAINT L/S WHITE
51092 NineMicrophones FAINT L/S BLACK
51095 NineMicrophones Sun forever2020 S/S WHITE
51096 NineMicrophones Sun forever2020 S/S IVORY
51097 NineMicrophones Sun forever2020 S/S BLACK
51105 NineMicrophones NEW MC CREW S/S WHITE
51106 NineMicrophones NEW MC CREW S/S BLACK
51117 NineMicrophones SNAPBACK CAP-NEW MC CREW- BLACK/WHITE
51123 NineMicrophones EFFECTOR BAG BLACK
52375 NineMicrophones ZIP PARKA-NEW MC CREW- BLACK
17819 NineMicrophones King Of The Road S/S CHARCOAL
54381 Nine Microphones -walkin'mic- S/S - WHITE
56547 Nine Microphones PRINTED POLO-9MC Crew-BKBRG