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-27 05:36:11')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 635)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
45096 MUSIC SAVED MY LIFE (MSML) M1H5K-JK01 BALLOON MODS COAT BLACK
56845 MUSIC SAVED MY LIFE (MSML) WOOL MAX COAT BLACK
56846 MUSIC SAVED MY LIFE (MSML) WOOL MAX COAT CAMEL
37649 MUSIC SAVED MY LIFE (MSML) REVERSIBLE BOMBER JKT RED CHECK-PINK
37650 【予約商品】MUSIC SAVED MY LIFE (MSML) REVERSIBLE BOMBER JKT GRAY CHECK-GOLD
37653 MUSIC SAVED MY LIFE (MSML) ZIP DENIM JKT LIGHT BLUE
37654 MUSIC SAVED MY LIFE (MSML) ZIP DENIM JKT INDIGO BLUE
45097 MUSIC SAVED MY LIFE (MSML) M1H5K-JK02 REVERSIBLE JACKET BLACK
45098 MUSIC SAVED MY LIFE (MSML) M1H5K-JK02 REVERSIBLE JACKET L.GRAY
50808 MUSIC SAVED MY LIFE (MSML) M101-01K5-KN01 ZIP KNIT ORANGE
50809 MUSIC SAVED MY LIFE (MSML) M101-01K5-KN01 ZIP KNIT BLACK
37688 MUSIC SAVED MY LIFE (MSML) JERSEY RIDERS JACKET BLACK
47469 MUSIC SAVED MY LIFE (MSML) M1K1K-JK02 BALLOON DENIM JACKET(加工) L.BLUE
30084 MUSIC SAVED MY LIFE (MSML) BOMBER JACKET BLACK
30085 MUSIC SAVED MY LIFE (MSML) BOMBER JACKET WHITE
45091 MUSIC SAVED MY LIFE (MSML) M1H5K-CS02 HEAVY FRENCHTERRY OVERSIZED PARKA BLACK
47470 MUSIC SAVED MY LIFE (MSML) M1K1K-JK01 BALLOON DENIM JACKET INDIGO
51713 MUSIC SAVED MY LIFE M2A1-01K5-WB01 LONG LEATHER WALLET BLACK
57066 MUSIC SAVED MY LIFE (MSML) LONG LEATHER WALLET
60771 MUSIC SAVED MY LIFE (MSML) OVERSIZED BOA RIDERS JACKET BLACK
37663 MUSIC SAVED MY LIFE (MSML) SARROUEL SKINNY DENIM PANTS LIGHT BLUE
37665 MUSIC SAVED MY LIFE (MSML) SARROUEL SKINNY DENIM PANTS WASHED BLACK
45099 MUSIC SAVED MY LIFE (MSML) M1H5K-PT01 SKINNY CARGO PANTS GRAY
45100 MUSIC SAVED MY LIFE (MSML) M1H5K-PT01 SKINNY CARGO PANTS BLACK
37651 MUSIC SAVED MY LIFE (MSML) SIDE LINE NYLON JKT BLACK
45090 MUSIC SAVED MY LIFE (MSML) M1H5K-KN01 PANTHER EMBROIDERY LONG CARDIGAN CAMEL
47311 MUSIC SAVED MY LIFE (MSML) M1K1T-JK03 TRACK JACKET BLACK
47312 MUSIC SAVED MY LIFE (MSML) M1K1T-JK03 TRACK JACKET RED
60534 MUSIC SAVED MY LIFE (MSML) DOUBLE CHAIN NECKLACE SILVER
56284 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT OFF WHITE
56285 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT GRAY
56849 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT PINK
56850 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT GRAY
51603 MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT BLACK
51604 【予約商品】MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT WHITE
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30087 MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT YELLOW
47317 MUSIC SAVED MY LIFE (MSML) M1K1K-PT01 NYLON SKINNY CARGO PANTS BLACK
56477 MUSIC SAVED MY LIFE (MSML)2LINE JERSEY PANTS
47471 MUSIC SAVED MY LIFE (MSML) M1K1K-PT02 SIDE LINE BLACK SKINNY PANTS BLACK&WHITE
51156 MUSIC SAVED MY LIFE SIDE LINE BLACK SKINNY DENIM PANTS BLACK&WHITE
56565 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON PARKA PURPLE
37656 MUSIC SAVED MY LIFE (MSML) BALLOON CHECK SHIRTS RED
37657 MUSIC SAVED MY LIFE (MSML) BALLOON CHECK SHIRTS BLUE
37690 MUSIC SAVED MY LIFE (MSML) JERSEY LINE TRACK PANTS BLACK
47313 MUSIC SAVED MY LIFE (MSML) M1K1T-PT03 TRACK PANTS BLACK
47314 MUSIC SAVED MY LIFE (MSML) M1K1T-SH01 BALLOON CHECK SHIRTS BLACK
47315 MUSIC SAVED MY LIFE (MSML) M1K1T-SH01 BALLOON CHECK SHIRTS BLUE
47316 MUSIC SAVED MY LIFE (MSML) M1K1T-SH01 BALLOON CHECK SHIRTS RED
50629 MUSIC SAVED MY LIFE M101-01K5-CL50 BALLOON SWITCHING SWEAT MUSTARD&IVORY
50630 MUSIC SAVED MY LIFE M101-01K5-CL50 BALLOON SWITCHING SWEAT RED&GRAY
50631 MUSIC SAVED MY LIFE M101-01K5-CL50 BALLOON SWITCHING SWEAT BLACK&PINK
50815 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BLACK
50816 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BEIGE
51160 MUSIC SAVED MY LIFE M101-01K5-PL03 2LINE JERSEY PANTS BLACK
51349 MUSIC SAVED MY LIFE CRAZY PATTERN BALLOON OMBRE CHECK SHIRTS BK&RD&BL
51605 MUSIC SAVED MY LIFE M101-02L1-SS02 CRAZY PATTERN SHIRT BLACK
51614 MUSIC SAVED MY LIFE M101-02L1-PL01 2LINE JERSEY PANTS BLACK×BLACK
51657 MUSIC SAVED MY LIFE M201-02L1-SS01 OPEN COLLAR SHORT SLEEVE SHIRT GREIGE
51658 MUSIC SAVED MY LIFE M201-02L1-SS01 OPEN COLLAR SHORT SLEEVE SHIRT BLACK
51660 MUSIC SAVED MY LIFE M201-02L1-SS02 MILITARY GRUNGE SHIRT KHAKI
56193 MUSIC SAVED MY LIFE (MSML) NYLON SARROUEL PANTS BLACK
56283 MUSIC SAVED MY LIFE (MSML) EMBROIDERY ZIP SWEAT BLACK
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
47579 MUSIC SAVED MY LIFE (MSML) M1K1T-PT05 2LINE COLOUR JERSEY PANTS BLACK
51662 MUSIC SAVED MY LIFE M201-02L1-PS01 WIDE SHORTS GREIGE
51663 MUSIC SAVED MY LIFE M201-02L1-PS01 WIDE SHORTS BLACK
56566 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT BLACK
34531 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT BLACK
34532 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT BLUE
34533 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT RED
37659 MUSIC SAVED MY LIFE (MSML) SIDE LINE NYLON PANTS BLACK
37661 MUSIC SAVED MY LIFE (MSML) 2LINE JERSEY BLACK
37674 【予約商品】MUSIC SAVED MY LIFE (MSML) ZIP WALLET BLACK
37678 MUSIC SAVED MY LIFE (MSML) SLEEVE EMBROIDERY SWEAT BLACK
37681 MUSIC SAVED MY LIFE (MSML) GRUNGE HOODIE GAWN BLACK
45127 MUSIC SAVED MY LIFE (MSML) M1H5T-PT03 2LINE COLOR JERSEY BLACK
45128 MUSIC SAVED MY LIFE (MSML) M1H5T-PT03 2LINE COLOR JERSEY MUSTARD
45129 MUSIC SAVED MY LIFE (MSML) M1H5T-PT03 2LINE COLOR JERSEY RED
47580 MUSIC SAVED MY LIFE (MSML) M1K1K-CS01 OVERSIZED GRUNGE PARKA BLACK
47581 MUSIC SAVED MY LIFE (MSML) M1K1K-CS01 OVERSIZED GRUNGE PARKA GRAY
47582 MUSIC SAVED MY LIFE (MSML) M1K1K-CS01 OVERSIZED GRUNGE PARKA RED
47583 MUSIC SAVED MY LIFE (MSML) M1K1K-CS01 OVERSIZED GRUNGE PARKA WHITE
51665 MUSIC SAVED MY LIFE M201-02L1-PS02 NYLON SARROUEL SHORTS BLACK
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
30094 MUSIC SAVED MY LIFE (MSML) LONG BRIM HAT CHARCOAL GRAY
30095 MUSIC SAVED MY LIFE (MSML) LONG BRIM HAT BLACK
45092 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 BLACK
45093 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 BEIGE
45094 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 GREEN
45095 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 RED
47465 MUSIC SAVED MY LIFE (MSML) M1K1T-AC02 ZIP LEATHER WALLET BLACK
47466 MUSIC SAVED MY LIFE (MSML) M1K1T-AC02 ZIP LEATHER WALLET RED
56281 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT BLACK
60416 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE BEIGE
34522 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE BLACK
34523 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE BROWN
34524 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE NAVY
51157 MUSIC SAVED MY LIFE M101-01K5-CL51 BIG HOODIE BLACK
51158 MUSIC SAVED MY LIFE M101-01K5-CL51 BIG HOODIE ORANGE
51159 MUSIC SAVED MY LIFE M101-01K5-CL51 BIG HOODIE BEIGE
60418 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE WHITE
30090 MUSIC SAVED MY LIFE (MSML) L/S LONG CUTSEW BLACK
30091 MUSIC SAVED MY LIFE (MSML) L/S LONG CUTSEW WHITE
37637 MUSIC SAVED MY LIFE (MSML) BIG HOODIE YELLOW
37638 MUSIC SAVED MY LIFE (MSML) BIG HOODIE RED
37639 MUSIC SAVED MY LIFE (MSML) BIG HOODIE WHITE
37640 MUSIC SAVED MY LIFE (MSML) BIG HOODIE BLACK
37641 MUSIC SAVED MY LIFE (MSML) BIG HOODIE KHAKI
37675 MUSIC SAVED MY LIFE (MSML) GRUNGE HOODIE BLACK
45068 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW BLACK
45069 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW KHAKI
45070 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW RED
45071 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW WHITE
45087 MUSIC SAVED MY LIFE (MSML) M1H5K-CS01 MESH LAYERED LONG SLEEVE BLACK
45088 MUSIC SAVED MY LIFE (MSML) M1H5K-CS01 MESH LAYERED LONG SLEEVE GRAY
45089 MUSIC SAVED MY LIFE (MSML) M1H5K-CS01 MESH LAYERED LONG SLEEVE WHITE
56286 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT ORANGE
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
30092 【予約商品】 MUSIC SAVED MY LIFE (MSML) HALF SLEEVE LONG CUTSEW BLACK