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-25 10:54:23')
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, 25
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