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 23:15:47')
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
LIMIT 0, 120
30084 MUSIC SAVED MY LIFE (MSML) BOMBER JACKET BLACK
30085 MUSIC SAVED MY LIFE (MSML) BOMBER JACKET WHITE
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30087 MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT YELLOW
30090 MUSIC SAVED MY LIFE (MSML) L/S LONG CUTSEW BLACK
30091 MUSIC SAVED MY LIFE (MSML) L/S LONG CUTSEW WHITE
30092 【予約商品】 MUSIC SAVED MY LIFE (MSML) HALF SLEEVE LONG CUTSEW BLACK
30093 MUSIC SAVED MY LIFE (MSML) HALF SLEEVE LONG CUTSEW WHITE
30094 MUSIC SAVED MY LIFE (MSML) LONG BRIM HAT CHARCOAL GRAY
30095 MUSIC SAVED MY LIFE (MSML) LONG BRIM HAT BLACK
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
34525 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TEE BLACK
34526 MUSIC SAVED MY LIFE (MSML) MESH LAYERED WHITE
34527 MUSIC SAVED MY LIFE (MSML) MESH LAYERED CHACOAL GRAY
34528 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP BLACK
34529 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP WHITE
34530 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP BROWN
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
34534 MUSIC SAVED MY LIFE (MSML) LONG SLEEVE BORDER CUTSEW KHAKI
34535 MUSIC SAVED MY LIFE (MSML) LONG SLEEVE BORDER CUTSEW BLACK&WHITE
34536 MUSIC SAVED MY LIFE (MSML) BIG-TEE BLACK
34537 MUSIC SAVED MY LIFE (MSML) BIG-TEE RED
34538 MUSIC SAVED MY LIFE (MSML) BIG-TEE WHITE
34539 MUSIC SAVED MY LIFE (MSML) BIG-TEE KHAKI
34540 MUSIC SAVED MY LIFE (MSML) BIG-TEE L.BLUE
34541 MUSIC SAVED MY LIFE (MSML) CAP BLACK
34542 MUSIC SAVED MY LIFE (MSML) CAP RED
34543 MUSIC SAVED MY LIFE (MSML) CAP WHITE
34544 MUSIC SAVED MY LIFE (MSML) CAP CAMO
34545 MUSIC SAVED MY LIFE (MSML) SHORT SLEEVE BORDER CUTSEW BLACK&WHITE
34547 MUSIC SAVED MY LIFE (MSML) TANK TOP BORDER CUTSEW BLACK&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
37642 MUSIC SAVED MY LIFE (MSML) CUT OFF LONG THERMAL BLACK
37643 【予約商品】MUSIC SAVED MY LIFE (MSML) CUT OFF LONG THERMAL WHITE
37645 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE PINK
37646 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE MINT BLUE
37647 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE LEAF GREEN
37648 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE BLACK
37649 MUSIC SAVED MY LIFE (MSML) REVERSIBLE BOMBER JKT RED CHECK-PINK
37650 【予約商品】MUSIC SAVED MY LIFE (MSML) REVERSIBLE BOMBER JKT GRAY CHECK-GOLD
37651 MUSIC SAVED MY LIFE (MSML) SIDE LINE NYLON JKT BLACK
37653 MUSIC SAVED MY LIFE (MSML) ZIP DENIM JKT LIGHT BLUE
37654 MUSIC SAVED MY LIFE (MSML) ZIP DENIM JKT INDIGO BLUE
37656 MUSIC SAVED MY LIFE (MSML) BALLOON CHECK SHIRTS RED
37657 MUSIC SAVED MY LIFE (MSML) BALLOON CHECK SHIRTS BLUE
37659 MUSIC SAVED MY LIFE (MSML) SIDE LINE NYLON PANTS BLACK
37661 MUSIC SAVED MY LIFE (MSML) 2LINE JERSEY 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
37671 MUSIC SAVED MY LIFE (MSML) LINE SOX RED LINE
37673 MUSIC SAVED MY LIFE (MSML) LINE SOX TRICO LINE
37674 【予約商品】MUSIC SAVED MY LIFE (MSML) ZIP WALLET BLACK
37675 MUSIC SAVED MY LIFE (MSML) GRUNGE HOODIE BLACK
37678 MUSIC SAVED MY LIFE (MSML) SLEEVE EMBROIDERY SWEAT BLACK
37681 MUSIC SAVED MY LIFE (MSML) GRUNGE HOODIE GAWN BLACK
37684 MUSIC SAVED MY LIFE (MSML) MESH LAYERED LONG SLEEVE TEE BLACK-WHITE
37685 MUSIC SAVED MY LIFE (MSML) MESH LAYERED LONG SLEEVE TEE WHITE-BLACK
37686 MUSIC SAVED MY LIFE (MSML) LIBERATE BIG TEE BLACK
37687 MUSIC SAVED MY LIFE (MSML) LIBERATE BIG TEE WHITE
37688 MUSIC SAVED MY LIFE (MSML) JERSEY RIDERS JACKET BLACK
37690 MUSIC SAVED MY LIFE (MSML) JERSEY LINE TRACK PANTS BLACK
37695 MUSIC SAVED MY LIFE (MSML) LOOSE BEANIE BLACK
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