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-23 20:34:53')
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)
LIMIT 0, 120
37671 MUSIC SAVED MY LIFE (MSML) LINE SOX RED LINE
37673 MUSIC SAVED MY LIFE (MSML) LINE SOX TRICO LINE
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
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
50626 MUSIC SAVED MY LIFE M1A1-01K5-GD01 LINE SOX NEON YELLOW
51632 【予約商品】MUSIC SAVED MY LIFE M1A1-GD01 LINE SOX WHITE&BLACK
51634 【予約商品】MUSIC SAVED MY LIFE M1A1-GD01 LINE SOX BLACK&WHITE
51676 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP BLACK
56163 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC LONG SLEEVE TEE PURPLE
47301 MUSIC SAVED MY LIFE (MSML) M1K1T-AC03 MASK BLACK&WHITE
56156 MUSIC SAVED MY LIFE (MSML) BANDANA LONG SLEEVE SLIT CUTSEW BLACK
50632 MUSIC SAVED MY LIFE (MSML) M201-01K5-TS02 BACK TO BASIC BIG 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
60417 MUSIC SAVED MY LIFE (MSML) ANGER LONG SLEEVE TEE
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
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
45102 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP ORANGE
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
56164 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP BLACK
56165 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP WHITE
56282 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT CHACOAL GRAY
60415 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE WHITE
60413 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GRAY
60414 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GREEN
47585 MUSIC SAVED MY LIFE (MSML) M1K1K-CS04 LAYERED TANK TOP (パンサープリント) WHITE
60759 MUSIC SAVED MY LIFE (MSML) OVERSIZED SIDE SLIT LONG CUTSEW BLACK
56567 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT PURPLE
51606 MUSIC SAVED MY LIFE M101-02L1-PS01 CROSSES WIDE SHORTS BLACK
37695 MUSIC SAVED MY LIFE (MSML) LOOSE BEANIE BLACK
37696 MUSIC SAVED MY LIFE (MSML) LOOSE BEANIE GRAY
56564 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON PARKA BLACK
37686 MUSIC SAVED MY LIFE (MSML) LIBERATE BIG TEE BLACK
37687 MUSIC SAVED MY LIFE (MSML) LIBERATE BIG TEE WHITE
51350 MUSIC SAVED MY LIFE CRAZY PATTERN BALLOON CHECK SHIRTS BLACK & RED & NAVY
51677 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP WHITE
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
60419 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE BLACK
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
34547 MUSIC SAVED MY LIFE (MSML) TANK TOP 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
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
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
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
56160 MUSIC SAVED MY LIFE (MSML) BOX LOGO LONG SLEEVE TEE BLACK
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
34545 MUSIC SAVED MY LIFE (MSML) SHORT SLEEVE BORDER CUTSEW BLACK&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
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
45101 MUSIC SAVED MY LIFE (MSML) M1H5K-AC01 BLACK NECKLESS BLACK
34534 MUSIC SAVED MY LIFE (MSML) LONG SLEEVE BORDER CUTSEW KHAKI
34535 MUSIC SAVED MY LIFE (MSML) LONG SLEEVE BORDER CUTSEW BLACK&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
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
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
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
51613 MUSIC SAVED MY LIFE M101-02L1-PL01 2LINE JERSEY PANTS BLACK×GREEN
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
51712 MUSIC SAVED MY LIFE M101-01K5-FW01 ZIP SNEAKER RED
56279 MUSIC SAVED MY LIFE (MSML) CAT OVERSIZED TEE WHITE
56280 MUSIC SAVED MY LIFE (MSML) CAT OVERSIZED TEE BLACK
57065 MUSIC SAVED MY LIFE (MSML) BLACK NECKLACE
60551 MUSIC SAVED MY LIFE (MSML) NYLON SAROUEL PANTS BLACK
30092 【予約商品】 MUSIC SAVED MY LIFE (MSML) HALF SLEEVE LONG CUTSEW BLACK
30093 MUSIC SAVED MY LIFE (MSML) HALF SLEEVE LONG CUTSEW WHITE
37642 MUSIC SAVED MY LIFE (MSML) CUT OFF LONG THERMAL BLACK
37643 【予約商品】MUSIC SAVED MY LIFE (MSML) CUT OFF LONG THERMAL WHITE
47584 MUSIC SAVED MY LIFE (MSML) M1K1K-CS04 LAYERED TANK TOP (パンサープリント) BLACK
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
51683 MUSIC SAVED MY LIFE M201-02L1-CL01 CAT OVERSIZED LONG SLEEVE TEE BLACK