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-22 00:23:34')
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 647)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 25
52974 acOlaSia PHENOMENON HOODIE BLACK
52976 acOlaSia ボディバッグ
54129 acOlaSia ENCHANT MARROW INSTILL L/S
54130 acOlaSia PIZZA MAD L/S BLACK
54730 acOlaSia “EXIT” big tee Black
54732 acOlaSia “KILL NOTICE” big tee Black
54734 acOlaSia “MONKEY BANANA” Tee
54735 acOlaSia “MONKEY BANANA” No sleeve
54737 acOlaSia “LOT””SKULL”ハイカットスニーカー SKULL
56001 acOlaSia MARLBONALD TEE BLACK
55999 acOlaSia LOSING MY MIND TEE BLACK
56086 acOlaSia SKULL SKATE tee black
56602 acOlaSia HOMINIDAE L/S BLACK
56604 acOlaSia INSANE L/S BLACK
56605 acOlaSia MAD DOG PULLOVER BLACK
57180 acOlaSia Camphell's コーチジャケット BLACK
57182 acOlaSia poison hoodie BLACK
57185 acOlaSia 煙仄 L/S BLACK
57187 acOlaSia SMILE MOON BEANIE BLACK
58382 acOlaSia Angel pic hoodie BLACK
58612 acOlaSia 浮世映 パーカー BLACK
58618 acOlaSia ILLUMINATI パーカー BLACK
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
60027 acOlaSia ロゴ シャワーサンダル
60239 acOlaSia VICTIM TEE BLACK