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 15:05:41')
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 MAX(price02)
LIMIT 0, 75
8307 Nine Microphones The angel soare S/S NAVY
23587 NineMicrophones BANDANNA-I'll stand by you- BLACK
23588 NineMicrophones BANDANNA-I'll stand by you- NAVY
32992 NineMicrophones KEY TAG BLACK
32993 NineMicrophones KEY TAG RED
32994 NineMicrophones KEY TAG BLUE
33031 NineMicrophones SAND CLOCK BANDANNA WHITE
29441 NineMicrophones (ナインマイクロフォンズ) VNECK S/S -Lightning- BLACK
56326 NineMicrophones NM/CS S/S BURGUNDY
13522 NineMicrophones TANK TOP-9MC Crew- BLACK/WHITE
41531 NineMicrophones CARABINER-NM- WHITE
41532 NineMicrophones CARABINER-NM- BURGUNDY
41533 NineMicrophones CARABINER-NM- MULTI
49915 NineMicrophones key holder WHITE/BLACK
49916 NineMicrophones key holder BLACK/WHITE
49917 NineMicrophones key holder MULTI
65361 NineMicrophones (ナインマイクロフォンズ) Carabiner BLACK
65362 NineMicrophones (ナインマイクロフォンズ) Carabiner BURGUNDY
65363 NineMicrophones (ナインマイクロフォンズ) Carabiner WHITE
59019 Nine Microphones EMERGE L/S - BLACK
61790 NineMicrophones 4way MASK HOLDER
33020 NineMicrophones 69YIN-YANG TANK TOP WHITE-BLACK
61471 NineMicrophones Description L/S WHITE
8299 Nine Microphones Pray with the microphone S/S NAVY
8306 Nine Microphones The angel soare S/S BLK
8309 Nine Microphones The angel soare S/S GRAY
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
10874 Nine Microphones The angel soare S/S White
12338 NineMicrophones 9MC SK8 PATTERNED TANK TOP WHITE
13529 NineMicrophones Power of will S/S BLACK/WHITE
16400 NineMicrophones 9MC Crew S/S - BLACK/BURGUNDY
17383 NineMicrophones TANK TOP-NINE BONES-
18767 NineMicrophones bronx S/S - WHITE
18770 NineMicrophones bronx S/S - GRAY
26032 NineMicrophones Power Of Will S/S WHT-BLK
33023 NineMicrophones ROLL SKIRT WHITE
34898 NineMicrophones SNAPBACKCAP-Comrade- BLACK-GOLD
41530 NineMicrophones BASQUE BERET BLACK
50674 NineMicrophones SOCKS-Name- BLACK
50675 NineMicrophones SOCKS-Name- WHITE
62613 NineMicrophones Chug S/S WHITE
62614 NineMicrophones Chug S/S BLACK
62615 NineMicrophones Chug S/S BURGUNDY
12456 NineMicrophones TATTO PRAYING HANDS S/S BLACK/BGN
12689 NineMicrophones Capricorn S/S WHITE/BROWN
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
20998 NineMicrophones Do or Die S/S BLK-BGN
20999 NineMicrophones Do or Die S/S CHARCOAL
21003 NineMicrophones Joy ride S/S BLACK
21006 NineMicrophones ANNOMARY S/S BLACK
34875 NineMicrophones COMPANY S/S BLACK
46159 NineMicrophones LOW CAP-Comrade- NAVY
12446 NineMicrophones GAME SHORTS -9MC Crew-BLACK/RED
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
25945 NineMicrophones METAL NECKLACE-9- SILVER
25946 NineMicrophones METAL NECKLACE-9- ANTIQUE SILVER
25947 NineMicrophones METAL NECKLACE-9- ANTIQUE GOLD
25948 NineMicrophones METAL NECKLACE-9- BRONDS
45727 NineMicrophones METAL NECKLACE-詩- ANTIQUE SILVER
47474 NineMicrophones METAL NECKLACE-詩- ANTIQUE GOLD
8444 Nine Microphones 9MC Crew 7/S NAVY
32932 NineMicrophones BIG TEE S/S-Comrade- WHITE
32933 NineMicrophones BIG TEE S/S-Comrade- BLACK
56323 NineMicrophones Lipsand Microphone S/S GRAY
56325 NineMicrophones NM/CS S/S BLACK
23499 NineMicrophones 9MC Crew S/S-CAMOUFLAGE- BLACK