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 06:29:55')
AND pc.price02 > 2727
AND price02 <= 4545
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 0, 75
56307 NineMicrophones PARKA-Pain of My life BLACK
59055 Nine Microphones FULLZIP NECK WARMER - BLACK
59018 Nine Microphones EMERGE L/S - WHITE
58996 NineMicrophones SWEAT-FULLERTON- BURGUNDY
56323 NineMicrophones Lipsand Microphone S/S GRAY
56325 NineMicrophones NM/CS S/S BLACK
56068 NineMicrophones PARKA-Power of will-GRAY
3187 NineMicrophones WALLET CHAIN -9MC Crew- BLK/WHT
6295 NineMicrophones WALLET CHAIN -9MC Crew- BLK/BGN
6297 NineMicrophones WALLET CHAIN -9MC Crew- BGN/MUS
8321 NineMicrophones WALLET CHAIN -9MC Crew- BLU/BLK
8444 Nine Microphones 9MC Crew 7/S NAVY
8446 Nine Microphones The angel soare L/S BLK/BRG
9235 Nine Microphones MESH CAP -Power of will- D.GREEN
12446 NineMicrophones GAME SHORTS -9MC Crew-BLACK/RED
12456 NineMicrophones TATTO PRAYING HANDS S/S BLACK/BGN
12689 NineMicrophones Capricorn S/S WHITE/BROWN
13523 NineMicrophones TANK TOP-9MC Crew- BLACK/BGN
13524 NineMicrophones TANK TOP -9MC Crew- WHITE
13525 NineMicrophones TANK TOP-9MC Crew- GRAY
13706 NineMicrophones Power of will R-7/S WHITE/BLACK
13797 NineMicrophones BORDER TEE S/S -9MC Crew- RED
14244 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/BGD
14245 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/WHT
16428 NineMicrophones TANK TOP-9MC Crew- - WHITE
16429 NineMicrophones TANK TOP-9MC Crew- - BLACK/WHITE
16430 NineMicrophones TANK TOP-9MC Crew BLACK/BURGUNDY
16469 NineMicrophones SUMMER BEANIE NAVY
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
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
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
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
23499 NineMicrophones 9MC Crew S/S-CAMOUFLAGE- BLACK
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
25977 NineMicrophones (ナインマイクロフォンズ) Light ZIP PARKA-Fight back- BLACK
26111 NineMicrophones BEANIE-Bronx- BLK
26112 NineMicrophones BEANIE-Bronx- MUS
26113 NineMicrophones BEANIE-Bronx- GRN
26114 NineMicrophones BEANIE-9MC Crew- BLK
26115 NineMicrophones BEANIE-9MC Crew- BGN
26116 NineMicrophones BEANIE-9MC Crew- NVY
29404 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLACK
29450 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- WHITE
29451 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- BLACK
29481 NineMicrophones (ナインマイクロフォンズ) iphone6,7 case-Back stage- BLACK
32932 NineMicrophones BIG TEE S/S-Comrade- WHITE
32933 NineMicrophones BIG TEE S/S-Comrade- BLACK
33021 NineMicrophones 69YIN-YANG TANK TOP BLACK-WHITE
33022 NineMicrophones 69YIN-YANG TANK TOP BLACK-BURGUNDY
34829 NineMicrophones COACH JACKET-how high- BLACK-YELLOW
34853 NineMicrophones INDIGO CHECK SHIRT L/S RED
34855 NineMicrophones INDIGO CHECK SHIRT L/S KHAKI
34875 NineMicrophones COMPANY S/S BLACK
34887 NineMicrophones BEANIE-Comrade- BLACK
34888 NineMicrophones BEANIE-Comrade- MUSTARD
34889 NineMicrophones BEANIE-Comrade- BURGUNDY
34890 NineMicrophones WATCHCAP-howhigh- BLACK-WHITE
34891 NineMicrophones WATCHCAP-howhigh- BLACK-YELLOW