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-18 13:54:17')
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, 120
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
41526 NineMicrophones FELT CAP NAVY
8446 Nine Microphones The angel soare L/S BLK/BRG
13706 NineMicrophones Power of will R-7/S WHITE/BLACK
13797 NineMicrophones BORDER TEE S/S -9MC Crew- RED
59018 Nine Microphones EMERGE L/S - WHITE
34829 NineMicrophones COACH JACKET-how high- BLACK-YELLOW
45310 NineMicrophones PARKA-badge- BLACK
56307 NineMicrophones PARKA-Pain of My life BLACK
29481 NineMicrophones (ナインマイクロフォンズ) iphone6,7 case-Back stage- BLACK
34853 NineMicrophones INDIGO CHECK SHIRT L/S RED
34855 NineMicrophones INDIGO CHECK SHIRT L/S KHAKI
50424 NineMicrophones PARKA-9MC LOCO- SILVER
50425 NineMicrophones PARKA-9MC LOCO- GOLD
56068 NineMicrophones PARKA-Power of will-GRAY
58996 NineMicrophones SWEAT-FULLERTON- BURGUNDY
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
13523 NineMicrophones TANK TOP-9MC Crew- BLACK/BGN
13524 NineMicrophones TANK TOP -9MC Crew- WHITE
13525 NineMicrophones TANK TOP-9MC Crew- GRAY
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
18804 NineMicrophones WATCH CAP -Higher than the BLK
18805 NineMicrophones WATCH CAP -Higher than the RED
18806 NineMicrophones WATCH CAP -Higher than the BLUE
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
45697 NineMicrophones KNAPSACK-Comrade- WHITE
45698 NineMicrophones KNAPSACK-Comrade- BLACK
29404 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLACK
9235 Nine Microphones MESH CAP -Power of will- D.GREEN
14244 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/BGD
14245 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/WHT
18801 NineMicrophones BEANIE -Power of will- BLACK
18802 NineMicrophones BEANIE -Power of will- BURGUNDY
25977 NineMicrophones (ナインマイクロフォンズ) Light ZIP PARKA-Fight back- BLACK
26111 NineMicrophones BEANIE-Bronx- BLK
26112 NineMicrophones BEANIE-Bronx- MUS