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-26 17:51:40')
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 0, 120
60759 MUSIC SAVED MY LIFE (MSML) OVERSIZED SIDE SLIT LONG CUTSEW BLACK
60760 MUSIC SAVED MY LIFE (MSML) OVERSIZED SIDE SLIT LONG CUTSEW CHARCOAL GRAY
60771 MUSIC SAVED MY LIFE (MSML) OVERSIZED BOA RIDERS JACKET BLACK
60534 MUSIC SAVED MY LIFE (MSML) DOUBLE CHAIN NECKLACE SILVER
60551 MUSIC SAVED MY LIFE (MSML) NYLON SAROUEL PANTS BLACK
60413 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GRAY
60414 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GREEN
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
60415 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE WHITE
60416 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE BEIGE
60418 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE WHITE
60419 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE BLACK
60417 MUSIC SAVED MY LIFE (MSML) ANGER LONG SLEEVE TEE
60420 MUSIC SAVED MY LIFE (MSML) EMBLEM NECKLACE
56849 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT PINK
51677 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP WHITE
56567 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT PURPLE
57066 MUSIC SAVED MY LIFE (MSML) LONG LEATHER WALLET
57065 MUSIC SAVED MY LIFE (MSML) BLACK NECKLACE
56845 MUSIC SAVED MY LIFE (MSML) WOOL MAX COAT BLACK
56846 MUSIC SAVED MY LIFE (MSML) WOOL MAX COAT CAMEL
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
56850 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT GRAY
47465 MUSIC SAVED MY LIFE (MSML) M1K1T-AC02 ZIP LEATHER WALLET BLACK
47466 MUSIC SAVED MY LIFE (MSML) M1K1T-AC02 ZIP LEATHER WALLET RED
51712 MUSIC SAVED MY LIFE M101-01K5-FW01 ZIP SNEAKER RED
56564 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON PARKA BLACK
56565 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON PARKA PURPLE
56566 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT BLACK
56477 MUSIC SAVED MY LIFE (MSML)2LINE JERSEY PANTS
56279 MUSIC SAVED MY LIFE (MSML) CAT OVERSIZED TEE WHITE
56280 MUSIC SAVED MY LIFE (MSML) CAT OVERSIZED TEE BLACK
56281 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT BLACK
56282 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT CHACOAL GRAY
56283 MUSIC SAVED MY LIFE (MSML) EMBROIDERY ZIP SWEAT BLACK
56284 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT OFF WHITE
56285 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT GRAY
56286 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT ORANGE
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
56193 MUSIC SAVED MY LIFE (MSML) NYLON SARROUEL PANTS BLACK
56156 MUSIC SAVED MY LIFE (MSML) BANDANA LONG SLEEVE SLIT CUTSEW BLACK
56157 MUSIC SAVED MY LIFE (MSML) COTTON MESH LONG SLEEVE SLIT CUTSEW BLACK
56158 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC TEE BLACK
56159 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC TEE WHITE
56160 MUSIC SAVED MY LIFE (MSML) BOX LOGO LONG SLEEVE TEE BLACK
56161 MUSIC SAVED MY LIFE (MSML) BOX LOGO LONG SLEEVE TEE PURPLE
56162 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC LONG SLEEVE TEE BLACK
56163 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC LONG SLEEVE TEE PURPLE
56164 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP BLACK
56165 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP WHITE
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