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 06:33:47')
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 50, 25
57194 acOlaSia LOGO BEANIE RED
57195 acOlaSia LOGO BEANIE PURPLE
57196 acOlaSia LOGO BEANIE ORANGE
57183 acOlaSia STAFF L/S WHITE
57184 acOlaSia STAFF L/S BLACK
58381 acOlaSia Angel pic hoodie WHITE
58382 acOlaSia Angel pic hoodie BLACK
58612 acOlaSia 浮世映 パーカー BLACK
58613 acOlaSia 浮世映 パーカー CHARCOAL
58614 acOlaSia 浮世映 パーカー ORANGE
58615 acOlaSia 浮世映 パーカー PINK
58616 acOlaSia 浮世映 パーカー BEIGE
58617 acOlaSia 浮世映 パーカー WHITE
58618 acOlaSia ILLUMINATI パーカー BLACK
58619 acOlaSia ILLUMINATI パーカー CHARCOAL
58620 acOlaSia ILLUMINATI パーカー ORANGE
58621 acOlaSia ILLUMINATI パーカー WHITE
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
60027 acOlaSia ロゴ シャワーサンダル
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