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-20 11:19:45')
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 p.update_date DESC
LIMIT 120, 120
37696 MUSIC SAVED MY LIFE (MSML) LOOSE BEANIE GRAY
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
45081 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP BLACK
45082 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP BLUE
45083 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP GREEN
45084 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP RED
45085 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP YELLOW
45086 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP 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
45090 MUSIC SAVED MY LIFE (MSML) M1H5K-KN01 PANTHER EMBROIDERY LONG CARDIGAN CAMEL
45091 MUSIC SAVED MY LIFE (MSML) M1H5K-CS02 HEAVY FRENCHTERRY OVERSIZED PARKA 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
45096 MUSIC SAVED MY LIFE (MSML) M1H5K-JK01 BALLOON MODS COAT BLACK
45097 MUSIC SAVED MY LIFE (MSML) M1H5K-JK02 REVERSIBLE JACKET BLACK
45098 MUSIC SAVED MY LIFE (MSML) M1H5K-JK02 REVERSIBLE JACKET L.GRAY
45099 MUSIC SAVED MY LIFE (MSML) M1H5K-PT01 SKINNY CARGO PANTS GRAY
45100 MUSIC SAVED MY LIFE (MSML) M1H5K-PT01 SKINNY CARGO PANTS BLACK
45101 MUSIC SAVED MY LIFE (MSML) M1H5K-AC01 BLACK NECKLESS BLACK
45102 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP ORANGE
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
47295 MUSIC SAVED MY LIFE (MSML) M1K1T-AC01 LINE SOX BLUE
47297 MUSIC SAVED MY LIFE (MSML) M1K1T-AC01 LINE SOX ORANGE
47298 MUSIC SAVED MY LIFE (MSML) M1K1T-AC01 LINE SOX RED
47301 MUSIC SAVED MY LIFE (MSML) M1K1T-AC03 MASK BLACK&WHITE
47302 MUSIC SAVED MY LIFE (MSML) M1K1K-CS02 LAYERED BIG TOPS BLACK
47303 MUSIC SAVED MY LIFE (MSML) M1K1K-CS02 LAYERED BIG TOPS CHACOAL GRAY
47304 MUSIC SAVED MY LIFE (MSML) M1K1K-CS02 LAYERED BIG TOPS WHITE
47305 MUSIC SAVED MY LIFE (MSML) M1K1K-CS03 LAYERED TANK TOP (スカルプリント) BLACK
47306 MUSIC SAVED MY LIFE (MSML) M1K1K-CS03 LAYERED TANK TOP (スカルプリント) WHITE
47307 MUSIC SAVED MY LIFE (MSML) M1K1K-AC02 PANTHER SOX RED
47308 MUSIC SAVED MY LIFE (MSML) M1K1K-AC02 PANTHER SOX WHITE
47309 MUSIC SAVED MY LIFE (MSML) M1K1K-AC03 LIBERATE SOX BLACK
47310 MUSIC SAVED MY LIFE (MSML) M1K1K-AC03 LIBERATE SOX WHITE
47311 MUSIC SAVED MY LIFE (MSML) M1K1T-JK03 TRACK JACKET BLACK
47312 MUSIC SAVED MY LIFE (MSML) M1K1T-JK03 TRACK JACKET RED
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
47317 MUSIC SAVED MY LIFE (MSML) M1K1K-PT01 NYLON SKINNY CARGO PANTS BLACK
47467 MUSIC SAVED MY LIFE (MSML) M1K1T-CP02 DENIM DAD CAP INDIGO
47468 MUSIC SAVED MY LIFE (MSML) M1K1T-CP02 DENIM DAD CAP L.BLUE
47469 MUSIC SAVED MY LIFE (MSML) M1K1K-JK02 BALLOON DENIM JACKET(加工) L.BLUE
47470 MUSIC SAVED MY LIFE (MSML) M1K1K-JK01 BALLOON DENIM JACKET INDIGO
47471 MUSIC SAVED MY LIFE (MSML) M1K1K-PT02 SIDE LINE BLACK SKINNY PANTS BLACK&WHITE
47579 MUSIC SAVED MY LIFE (MSML) M1K1T-PT05 2LINE COLOUR JERSEY PANTS BLACK
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
47584 MUSIC SAVED MY LIFE (MSML) M1K1K-CS04 LAYERED TANK TOP (パンサープリント) BLACK
47585 MUSIC SAVED MY LIFE (MSML) M1K1K-CS04 LAYERED TANK TOP (パンサープリント) WHITE
47586 MUSIC SAVED MY LIFE (MSML) M1K1K-CS06 BIG TEE (パンサープリント) BLACK
47587 MUSIC SAVED MY LIFE (MSML) M1K1K-CS06 BIG TEE (パンサープリント) GRAY
47588 MUSIC SAVED MY LIFE (MSML) M1K1K-CS06 BIG TEE (パンサープリント) WHITE
47742 MUSIC SAVED MY LIFE (MSML) M1K1T-CS02 BIG TEE BLACK
47743 MUSIC SAVED MY LIFE (MSML) M1K1T-CS02 BIG TEE KHAKI
47744 MUSIC SAVED MY LIFE (MSML) M1K1T-CS02 BIG TEE ORANGE
47745 MUSIC SAVED MY LIFE (MSML) M1K1T-CS02 BIG TEE WHITE
47746 MUSIC SAVED MY LIFE (MSML) M1K1K-CS05 BIG TEE (スカルプリント) BLACK
47747 MUSIC SAVED MY LIFE (MSML) M1K1K-CS05 BIG TEE (スカルプリント) GRAY
47748 MUSIC SAVED MY LIFE (MSML) M1K1K-CS05 BIG TEE (スカルプリント) WHITE
50626 MUSIC SAVED MY LIFE M1A1-01K5-GD01 LINE SOX NEON YELLOW
50627 MUSIC SAVED MY LIFE (MSML) M201-01K5-TL01 LOGO LONG SLEEVE TEE BLACK
50628 MUSIC SAVED MY LIFE (MSML) M201-01K5-TL01 LOGO LONG SLEEVE TEE WHITE
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
50632 MUSIC SAVED MY LIFE (MSML) M201-01K5-TS02 BACK TO BASIC BIG TEE BLACK
50633 MUSIC SAVED MY LIFE (MSML) M201-01K5-TS02 BACK TO BASIC BIG TEE WHITE
50634 MUSIC SAVED MY LIFE M201-01K5-TS03 STONE STATUE LONG LENGTH TEE BLACK
50635 MUSIC SAVED MY LIFE M201-01K5-TS03 STONE STATUE LONG LENGTH TEE WHITE
50636 MUSIC SAVED MY LIFE M201-01K5-TS04 SNAKE LONG LENGTH TEE BLACK
50637 MUSIC SAVED MY LIFE M201-01K5-TS04 SNAKE LONG LENGTH TEE WHITE
50808 MUSIC SAVED MY LIFE (MSML) M101-01K5-KN01 ZIP KNIT ORANGE
50809 MUSIC SAVED MY LIFE (MSML) M101-01K5-KN01 ZIP KNIT BLACK
50810 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE BLACK
50811 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE BEIGE
50812 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE ORANGE
50813 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE WHITE
50814 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE YELLOW
50815 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BLACK
50816 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BEIGE
51156 MUSIC SAVED MY LIFE SIDE LINE BLACK SKINNY DENIM PANTS BLACK&WHITE
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
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
51350 MUSIC SAVED MY LIFE CRAZY PATTERN BALLOON CHECK SHIRTS BLACK & RED & NAVY
51603 MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT BLACK
51604 【予約商品】MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT WHITE
51605 MUSIC SAVED MY LIFE M101-02L1-SS02 CRAZY PATTERN SHIRT BLACK
51606 MUSIC SAVED MY LIFE M101-02L1-PS01 CROSSES WIDE SHORTS BLACK
51613 MUSIC SAVED MY LIFE M101-02L1-PL01 2LINE JERSEY PANTS BLACK×GREEN
51614 MUSIC SAVED MY LIFE M101-02L1-PL01 2LINE JERSEY PANTS BLACK×BLACK
51616 MUSIC SAVED MY LIFE M101-02L1-CS01 BORDER LAYERED TANK TOP BLACK
51617 MUSIC SAVED MY LIFE M101-02L1-CS01 BORDER LAYERED TANK TOP WHITE
51629 MUSIC SAVED MY LIFE M101-02L1-CL01 GRAPHIC LONG SLEEVE TEE WHITE
51630 MUSIC SAVED MY LIFE M101-02L1-CL01 GRAPHIC LONG SLEEVE TEE ORANGE
51632 【予約商品】MUSIC SAVED MY LIFE M1A1-GD01 LINE SOX WHITE&BLACK
51634 【予約商品】MUSIC SAVED MY LIFE M1A1-GD01 LINE SOX BLACK&WHITE
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
51662 MUSIC SAVED MY LIFE M201-02L1-PS01 WIDE SHORTS GREIGE
51663 MUSIC SAVED MY LIFE M201-02L1-PS01 WIDE SHORTS BLACK
51665 MUSIC SAVED MY LIFE M201-02L1-PS02 NYLON SARROUEL SHORTS BLACK
51676 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP BLACK
51683 MUSIC SAVED MY LIFE M201-02L1-CL01 CAT OVERSIZED LONG SLEEVE TEE BLACK