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-18 00:28:11')
AND pc.classcategory_id1 IN( 13,35,44)
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
52506 【限定コラボ・アイテム】Merm4id × PLMP Collaboration S/S TEE
53914 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA WHITE
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE
53916 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLACK
53918 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA RED
53919 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA BLACK
54097 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE SAX
54098 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE RED
54099 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE WHITE
54100 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE BLACK
54101 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE WHITE/BLUE
54764 PSYCHOLOGICAL METAMORPHOSIS PMLP STRIPE EAZY PANTS WHITE/NAVY
54763 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS BLACK
54761 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS RED
54762 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS SAX
54767 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS BLACK
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
54766 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS SAX
55559 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE BLACK
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
55557 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE WHITE
55556 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BLACK
55555 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BURGANDY
55554 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE KHAKI
55847 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO SS TEE WHITE