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-04-30 20:24:11')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 653)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 25
38721 PSYCHOLOGICAL METAMORPHOSIS PLMP-17-06 PMLP L/S LOGO WHITE
38722 PSYCHOLOGICAL METAMORPHOSIS PLMP-17-06 PMLP L/S LOGO BLACK
38723 PSYCHOLOGICAL METAMORPHOSIS PLMP-17-06 PMLP L/S LOGO BLUE
38724 PSYCHOLOGICAL METAMORPHOSIS PMLP L/S CIRCLE BLACK
38725 PSYCHOLOGICAL METAMORPHOSIS PMLP L/S CIRCLE WHITE
38726 PSYCHOLOGICAL METAMORPHOSIS PMLP L/S CIRCLE BLUE
38727 PSYCHOLOGICAL METAMORPHOSIS PMLP PARKA LOGO / WHITE
38728 PSYCHOLOGICAL METAMORPHOSIS PMLP PARKA LOGO / BLACK
38729 PSYCHOLOGICAL METAMORPHOSIS PMLP PARKA LOGO / BLUE
41296 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S MARK ORANGE
41297 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S MARK BLACK
41298 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S MARK SAX
41299 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2 WHITE
41300 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2 BLACK
41301 PSYCHOLOGICAL METAMORPHOSIS PLMP COACH JKT BLACK
41302 PSYCHOLOGICAL METAMORPHOSIS PLMP COACH JKT BEIGE
41303 PSYCHOLOGICAL METAMORPHOSIS PLMP SACOCHE BLACK
41304 PSYCHOLOGICAL METAMORPHOSIS PLMP BACK PACK BLACK
41305 PSYCHOLOGICAL METAMORPHOSIS PLMP BACK PACK BROWN
41306 PSYCHOLOGICAL METAMORPHOSIS PLMP JET CAP OLIVE
41307 PSYCHOLOGICAL METAMORPHOSIS PLMP CORDY CAP BLACK
41308 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO CAP BEIGE
41309 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO CAP BLACK
41310 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO CAP CHARCHOAL
41311 PSYCHOLOGICAL METAMORPHOSIS PLMP CORDY CAP BURGUNDY