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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-30 19:15:06')
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) DESC
LIMIT 0, 120
39725 NineMicrophones FAINT WHITE
39726 NineMicrophones FAINT BLACK
41953 NineMicrophones PIGMENT FOOTBALL TEE YELLOW
41954 NineMicrophones PIGMENT FOOTBALL TEE GRAY
16396 NineMicrophones FOOTBALL TEE-King Of The Road- BLK
16397 NineMicrophones FOOTBALL TEE-King Of The Road- BGN
12436 NineMicrophones GAME SHIRT Ⅱ -9MC Crew-BLACK/GRAY
26085 NineMicrophones (ナインマイクロフォンズ) Lone wolf S/S BLACK
21000 NineMicrophones Sun forever S/S WHITE
21001 NineMicrophones Sun forever S/S BLACK
23511 NineMicrophones Sun forever S/S - BURGUNDY
23498 NineMicrophones 9MC Crew S/S-CAMOUFLAGE- WHITE
45742 NineMicrophones STAY REAL S/S BLACK
45743 NineMicrophones STAY REAL S/S WHITE
12345 NineMicrophones 9MC SK8 PATTERNED VNECK S/S BLUE
17380 NineMicrophones NINE BONES S/S WHITE
17381 NineMicrophones NINE BONES S/S BLACK
26072 NineMicrophones (ナインマイクロフォンズ) Ta2 the world S/S WHT/BLK
26074 NineMicrophones (ナインマイクロフォンズ) Ta2 the world S/S BLK/WHT
26076 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S WHT/BLK
26077 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S WHT/BGN
26078 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S BLK/WHT
26079 NineMicrophones (ナインマイクロフォンズ) Pray for skull S/S BLK/BGN
51095 NineMicrophones Sun forever2020 S/S WHITE
51096 NineMicrophones Sun forever2020 S/S IVORY
51097 NineMicrophones Sun forever2020 S/S BLACK
56322 NineMicrophones Lipsand Microphone S/S WHITE
70954 NineMicrophones(ナインマイクロフォンズ) Libertad TEE WHITE
70956 NineMicrophones(ナインマイクロフォンズ) Libertad TEE BLACK
39727 NineMicrophones STRONGER WHITE
39728 NineMicrophones STRONGER GRAY
47472 NineMicrophones Board S/S BLACK
47473 NineMicrophones Board S/S WHITE
12448 NineMicrophones MUD SKULL S/S BLACK
12449 NineMicrophones MUD SKULL S/S DENIM
12507 NineMicrophones Attitude of Faith S/S BLACK
12508 NineMicrophones Attitude of Faith S/S WHITE
26080 NineMicrophones (ナインマイクロフォンズ) Strum your mind S/S WHITE
26081 NineMicrophones (ナインマイクロフォンズ) Strum your mind S/S BLACK
29421 NineMicrophones (ナインマイクロフォンズ) Honor S/S WHITE
29422 NineMicrophones (ナインマイクロフォンズ) Honor S/S BLACK
33014 NineMicrophones 69LOGO TEE S/S WHITE-BLACK
33015 NineMicrophones 69LOGO TEE S/S BLACK-WHITE
33016 NineMicrophones 69LOGO TEE S/S BLACK-BURGUNDY
65376 NineMicrophones (ナインマイクロフォンズ) Rose S/S WHITE
65377 NineMicrophones (ナインマイクロフォンズ) Rose S/S WHIT Rose S/S BLACK
71533 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone TEE BURGUNDY
3555 Nine Microphones Pray with the microphone R-S/S BK
12453 NineMicrophones Arms No Fear S/S CHARCOAL
12679 NineMicrophones WHAT I GOT S/S WHITE/BGN
12680 NineMicrophones WHAT I GOT S/S BLACK/BGN
12684 NineMicrophones Mind of cupid S/S BLACK/BGN
12688 NineMicrophones Capricorn S/S BLACK/BROWN
12690 NineMicrophones Capricorn S/S BLACK/BGN
16410 NineMicrophones Strength and honor S/S - WHITE
16412 NineMicrophones Strength and honor S/S - BLK/ORG
17819 NineMicrophones King Of The Road S/S CHARCOAL
20997 NineMicrophones Do or Die S/S WHITE
23500 NineMicrophones The game of life S/S - WHITE
23501 NineMicrophones The game of life S/S - BLACK/WHITE
28251 NineMicrophones (ナインマイクロフォンズ) POCKET S/S TEE
29424 NineMicrophones (ナインマイクロフォンズ) Pass the mic S/S WHITE
29425 NineMicrophones (ナインマイクロフォンズ) Pass the mic S/S BLACK
32939 NineMicrophones Pass the mic S/S GRAY
32940 NineMicrophones Pass the mic S/S BURGUNDY
32956 NineMicrophones V-NECK TEE S/S -INK- WHITE
32957 NineMicrophones V-NECK TEE S/S -INK- BLACK
34874 NineMicrophones COMPANY S/S WHITE
37881 NineMicrophones Fellow S/S WHITE
37882 NineMicrophones Fellow S/S BLACK
39721 NineMicrophones PROMOTION WHITE
39722 NineMicrophones PROMOTION BLACK
47830 NineMicrophones ""K""ABUKI-MONO S/S GRAY
47831 NineMicrophones ""K""ABUKI-MONO S/S WHITE
4227 Nine Microphones MAD SKULL S/S BK/WH
8311 Nine Microphones bronx S/S BLACK/BURGUNDY
8312 NineMicrophones bronx S/S BLACK/WHITE
10875 Nine Microphones The angel soare S/S Black
11229 Nine Microphones HEAVEN S/S Gray
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
11289 Nine Microphones FATAL S/S BLACK
11502 NineMicrophones SHOUT SKULL S/S BLACK/MUSTARD
11503 NineMicrophones SHOUT SKULL S/S NAVY/MUSTARD
13528 NineMicrophones Power of will S/S WHITE
13530 NineMicrophones Power of will S/S BLACK/BGN
13531 NineMicrophones Power of will S/S GRAY
13532 NineMicrophones Power of will S/S BGN
13533 NineMicrophones Power of will S/S NAVY
16399 NineMicrophones 9MC Crew S/S - BLACK/WHITE
16401 NineMicrophones 9MC Crew S/S - BURGUNDY
18763 NineMicrophones 9MICS Crew S/S - WHITE-BLACK
18764 NineMicrophones 9MICS Crew S/S - BLACK-WHITE
18765 NineMicrophones 9MICS Crew S/S - BLACK-BURGUNDY
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
23525 NineMicrophones 9MICS Crew S/S - WHITE/S BLUE
23526 NineMicrophones 9MICS Crew S/S - GREEN/YELLOW
23537 NineMicrophones Power Of Will S/S - NAVY/MUSTARD
25329 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone S/S BLACK/MUSTARD
26024 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone S/S WHT/WHT
26026 NineMicrophones Pray with the microphone S/S BLK/BLK
26038 NineMicrophones (ナインマイクロフォンズ) 9MICS Crew S/S WHT/BGN
26040 NineMicrophones (ナインマイクロフォンズ) 9MICS Crew S/S RED/WHT
29431 NineMicrophones (ナインマイクロフォンズ) 9MICS Crew S/S WHITE-RED
34872 NineMicrophones LOCAL S/S WHITE
34873 NineMicrophones LOCAL S/S BLACK
34876 NineMicrophones Crown S/S WHITE
34877 NineMicrophones Crown S/S BLACK
34878 NineMicrophones Crown S/S YELLOW
34879 NineMicrophones V NECK TEE-Comrade- WHITE
34880 NineMicrophones V NECK TEE-Comrade- BLACK
45740 NineMicrophones Way of Life S/S BLACK
45741 NineMicrophones Way of Life S/S WHITE
46160 NineMicrophones BIGTEE-Sing- BLACK
49739 NineMicrophones Pray with the microphone S/S WHITE
49740 NineMicrophones Pray with the microphone S/S BLACK
51105 NineMicrophones NEW MC CREW S/S WHITE
51106 NineMicrophones NEW MC CREW S/S BLACK