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 21:20: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 25, 25
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
56849 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT PINK
56850 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT GRAY
57065 MUSIC SAVED MY LIFE (MSML) BLACK NECKLACE
57066 MUSIC SAVED MY LIFE (MSML) LONG LEATHER WALLET
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
60413 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GRAY
60414 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GREEN
60415 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE WHITE
60416 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE BEIGE
60417 MUSIC SAVED MY LIFE (MSML) ANGER LONG SLEEVE TEE
60418 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE WHITE
60419 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE BLACK
60420 MUSIC SAVED MY LIFE (MSML) EMBLEM NECKLACE
60534 MUSIC SAVED MY LIFE (MSML) DOUBLE CHAIN NECKLACE SILVER
60551 MUSIC SAVED MY LIFE (MSML) NYLON SAROUEL PANTS BLACK
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