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-17 21:55:05')
AND FIND_IN_SET(1, p.color)
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
53916 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLACK
53919 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA BLACK
54100 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE BLACK
54764 PSYCHOLOGICAL METAMORPHOSIS PMLP STRIPE EAZY PANTS WHITE/NAVY
54763 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS BLACK
54767 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS BLACK
55559 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE BLACK
55556 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BLACK
55848 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO SS TEE BLACK
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
55800 【バンドリ!×ゲキクロ 第2弾復刻】PSYCHOLOGICAL METAMORPHOSIS×戸山香澄コラボ 限定 コーチJKT
58569 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP BLACK
59100 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO TEE BLACK
59310 PSYCHOLOGICAL METAMORPHOSIS INVERSION LOGO TEE BLACK
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK
59867 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BLACK
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
59230 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLACK×RED
60055 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE ORG-BLK
60054 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE BLU-BLK
58634 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 01 BLACK
60181 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin.SS TEE 03 BLACK
52487 【バンドリ!×ゲキクロ 第4弾復刻】PSYCHOLOGICAL METAMORPHOSIS×大和 麻弥 コラボ 限定 キャップ
52485 【バンドリ!×ゲキクロ 第4弾復刻】PSYCHOLOGICAL METAMORPHOSIS×大和 麻弥 コラボ 限定 パーカー
61559 PSYCHOLOGICAL METAMORPHOSIS MOCK NECK HEAVY TEE BLACK