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 19:36:57')
AND pc.price02 > 9090
AND price02 <= 13636
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, 120
70068 NineMicrophones(ナインマイクロフォンズ) COACH JKT-9MC Crew- BLACK
70069 NineMicrophones(ナインマイクロフォンズ) COACH JKT-9MC Crew- BURGUNDY
70072 NineMicrophones(ナインマイクロフォンズ) ZIP PARKA-Pray with the microphone- GRAY
70070 NineMicrophones(ナインマイクロフォンズ) COACH JKT-9MC Crew- BROWN
70071 NineMicrophones(ナインマイクロフォンズ) ZIP PARKA-Pray with the microphone- BLACK
66682 NineMicrophones(ナインマイクロフォンズ) SWEAT-Pray with the microphone- BLACK
66681 NineMicrophones(ナインマイクロフォンズ) SWEAT-Pray with the microphone- GRAY
66800 NineMicrophones(ナインマイクロフォンズ) SWEAT-Sunforever2023- BLACK
66799 NineMicrophones(ナインマイクロフォンズ) SWEAT-Sunforever2023- NAVY
66798 NineMicrophones(ナインマイクロフォンズ) SWEAT-Sunforever2023- GRAY
66680 NineMicrophones(ナインマイクロフォンズ) SWEAT-Pray with the microphone- WHITE
61405 NineMicrophones SWEAT-Wanderer- BLACK
61406 NineMicrophones SWEAT-Wanderer- BURGUNDY
61404 NineMicrophones SWEAT-Wanderer- WHITE
65379 NineMicrophones (ナインマイクロフォンズ) SWEAT-Rose- BLACK
65378 NineMicrophones (ナインマイクロフォンズ) SWEAT-Rose- WHITE
66459 NineMicrophones (ナインマイクロフォンズ) ZIP PARKA-9MC Loco- BLACK
66460 NineMicrophones (ナインマイクロフォンズ) ZIP PARKA-9MC Loco- GRAY
58995 Nine Microphones SWEAT-FULLERTON- GRAY
56313 NineMicrophones PARKA-Sunforever2021- BLACK
56314 NineMicrophones PARKA-Sunforever2021- GRAY
56067 NineMicrophones PARKA-Power of will-BLACK
54361 Nine Microphones PARKA-Sunforever2020aw- BLACK
54362 Nine Microphones PARKA-Sunforever2020aw- GRAY
37860 NineMicrophones PARKA-Pray with the microphones- BLACK/WHITE
51136 NineMicrophones PARKA-Pray with the microphones- GRAY
4406 Nine Microphones LEATHER BELT -Punk Skater-WH/BK
4407 NineMicrophones LEATHER BELT -Punk Skater-BK/WH
7801 Nine Microphones CHECK SHIRT S/S-Blood Sympathy-RD
11554 NineMicrophones WORK SHORTS EMBROIDRY-9MC- BLK/W
11958 NineMicrophones WORK SHIRT S/S -Power- MAS
12437 NineMicrophones PAISLEY SHIRT S/S -Power-WHITE
12438 NineMicrophones PAISLEY SHIRT S/S -Power-BEIGE
12439 NineMicrophones PAISLEY SHIRT S/S -Power-GREEN
12440 NineMicrophones PAISLEY SHIRT S/S -Power-BLACK
12442 NineMicrophones STRIPE SHIRT S/S -bronx-BLACK
12443 NineMicrophones STRIPE SHIRT S/S -bronx-WHITE
12467 NineMicrophones PATCHWORK SHIRT S/S -FIGHT- BLACK
12470 NineMicrophones PATCHWORK SHIRT S/S -FIGHT-GRAY
13709 NineMicrophones COACH JKT -9MC Crew- BLACK/WHITE
13712 NineMicrophones ZIP PARKA -TATTOO MACHINE-BLK/WHT
13736 NineMicrophones ZIP PARKA -9MC Crew- BLK/BGN
13737 NineMicrophones ZIP PARKA -9MC Crew- NAVY
14239 NineMicrophones CHECK HOODY SHIRTS-Comrade- NAVY
14649 NineMicrophones PATCHWORK SWEATER BLACK/BURGUNDY
14651 NineMicrophones PATCHWORK SWEATER NAVY
14741 NineMicrophones 9MC Loco PARKA NAVY
14742 NineMicrophones 9MC Loco PARKA CHACOAL
15786 NineMicrophones ZIP PARKA-King Of The Road- BLK/RE
15792 NineMicrophones ZIP PARKA-King Of The Road- BLK/WH
15896 Nine Microphones 9MC Loco PARKA CHARCOAL GRAY
16449 NineMicrophones WORK SHORTS-Comrade- BLACK
16450 NineMicrophones WORK SHORTS-Comrade- BEIGE
17566 NineMicrophones CHECK L/S-King Of The Road- NAVY
17567 NineMicrophones CHECK L/S-King Of The Road-MUSTARD
17568 NineMicrophones CHECK L/S-King Of The Road- BGN
17569 NineMicrophones STRIPE SHIRT L/S-bronx- WHITE
17570 NineMicrophones STRIPE SHIRT L/S-bronx- NAVY
17571 NineMicrophones STRIPE SHIRT L/S-Power Of Will-WHT
17572 NineMicrophones STRIPE SHIRT L/S-Power Of Will-BLK
17574 NineMicrophones PAISLEY S/S-King Of The Road- WHT
17575 NineMicrophones PAISLEY S/S-King Of The Road- BGN
17576 NineMicrophones PAISLEY S/S-King Of The Road- BLK
18717 NineMicrophones PARKA -RUN 9MC- BLACK
18720 NineMicrophones PARKA -9MC ASSOCIATION- BLACK
18726 NineMicrophones ZIP PARKA -9MC Crew- GRAY
18727 NineMicrophones ZIP PARKA -9MC Crew- - NAVY
18728 NineMicrophones ZIP PARKA -Comrade- - BLACK
18730 NineMicrophones ZIP PARKA -Comrade- - NAVY
18732 NineMicrophones 9MC Loco PARKA NAVY
18739 NineMicrophones CHECK SHIRTL/S -Comrade- BLACK
20025 NineMicrophones SWEAT PANTS-Deff posse- BLACK
20957 NineMicrophones ZIP PARKA -9MC Crew- WHITE
23476 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/WHITE
23477 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/BURGUNDY
23480 NineMicrophones WORK SHIRT S/S-The 9- BLACK
23481 NineMicrophones WORK SHIRT S/S-The 9- - BLUE
23487 NineMicrophones CHECK SHIRT S/S-Comrade- - BLACK
23488 NineMicrophones CHECK SHIRT S/S-Comrade- - RED
23489 NineMicrophones CHECK SHIRT S/S-Comrade- - BLUE
23554 NineMicrophones ALOHA SHORTS - BLACK
25951 NineMicrophones COACH JACKET-Pray with the microphone- BLACK/WHITE
25952 NineMicrophones COACH JACKET-Pray with the microphone- WHITE/BLACK
25953 NineMicrophones COACH JACKET-Pray with the microphone- BURGUNDY
25954 NineMicrophones COACH JACKET-Pray with the microphone- CHARCOAL
25983 NineMicrophones ZIP PARKA -9MC Crew- GREEN
25995 NineMicrophones (ナインマイクロフォンズ) SWEAT-CAMOUFLAGE 9MC Crew- WHITE
25996 NineMicrophones (ナインマイクロフォンズ) SWEAT-CAMOUFLAGE 9MC Crew- BLACK
26012 NineMicrophones CAMOUFLAGE SHIRT-Strum your mind- BLACK
26013 NineMicrophones CAMOUFLAGE SHIRT-Strum your mind- KHAKI
26021 NineMicrophones DENIM SHIRT L/S-Pray with the microphones- INDIGO
26022 NineMicrophones DENIM SHIRT L/S-Pray with the microphones- BLK
29388 NineMicrophones (ナインマイクロフォンズ) Packable ANORAK-F.O.B- RED
29389 NineMicrophones (ナインマイクロフォンズ) Packable ANORAK-F.O.B- BLUE
29392 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- BLACK
29393 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- GRAY
29394 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- BURGUNDY
29395 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- WHITE
29396 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- BLACK
29397 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- GRAY
29398 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- WHITE
29399 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- BLACK-WHITE
29400 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- BLACK-BURGUNDY
29401 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- GRAY
29402 NineMicrophones (ナインマイクロフォンズ) SWEAT -Lightning- WHITE
29403 NineMicrophones (ナインマイクロフォンズ) SWEAT -Lightning- BLACK
29410 NineMicrophones (ナインマイクロフォンズ) FOOTBALL SHIRT-9MC Crew- BLACK
29411 NineMicrophones (ナインマイクロフォンズ) FOOTBALL SHIRT-9MC Crew- NAVY
29469 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT BLACK
29470 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT CAMEL
32928 NineMicrophones ALOHA SHIRT-Pizzalia- WHITE
32929 NineMicrophones ALOHA SHIRT-Pizzalia- BLACK
32976 NineMicrophones ALOHA SHORTS-Pizzalia- WHITE
32977 NineMicrophones ALOHA SHORTS-Pizzalia- BLACK
34826 NineMicrophones COACH JACKET-Rebel label- BLACK
34827 NineMicrophones COACH JACKET-Rebel label- GREEN
34828 NineMicrophones COACH JACKET-how high- BLACK-WHITE
34830 NineMicrophones COACH JACKET-how high- BURGUNDY
34839 NineMicrophones PARKA-DELTA- GRAY
34840 NineMicrophones PARKA-DELTA- ORANGE