SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-05-23 01:07:43')
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
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
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