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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-01 20:04:10')
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 DESC
LIMIT 0, 25
69169 acOlaSia (アコレイジア)Thanatos tee White
69168 acOlaSia (アコレイジア)Thanatos tee Black
69167 acOlaSia (アコレイジア)Melancholy Twins tee White
69166 acOlaSia (アコレイジア)Melancholy Twins tee Black
64888 acOlaSia (アコレイジア) GAMING ERROR tee BLUE
64889 acOlaSia (アコレイジア) HUNGRY tee WHITE
64890 acOlaSia (アコレイジア) RABBIT tee WHITE
64891 acOlaSia (アコレイジア) RABBIT tee BLUE
64892 acOlaSia (アコレイジア) RABBIT tee BLACK
64895 acOlaSia (アコレイジア) GAMING ERROR tee WHITE
64898 acOlaSia (アコレイジア) GAMING ERROR tee BLACK
64899 acOlaSia (アコレイジア) HUNGRY tee BLUE
64900 acOlaSia (アコレイジア) HUNGRY tee BLACK
60247 acOlaSia NEXT IS YOU TEE BLACK
60239 acOlaSia VICTIM TEE BLACK
60240 acOlaSia VICTIM TEE WHITE
60241 acOlaSia FRIDAY BACK PRINT TEE BLACK
60242 acOlaSia FRIDAY BACK PRINT TEE WHITE
60243 acOlaSia I DON'T GIVE A SHIT TEE BLACK
60244 acOlaSia I DON'T GIVE A SHIT TEE WHITE
60245 acOlaSia MEDAMAYAKI TEE BLACK
60246 acOlaSia MEDAMAYAKI TEE WHITE
60248 acOlaSia NEXT IS YOU TEE WHITE
55755 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 Tシャツ
56083 acOlaSia SKULL BATTERY tee white