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-23 02:27:15')
AND FIND_IN_SET(3, 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 MAX(price02)
LIMIT 0, 25
44923 【ゲキクロ限定】acOlaSia STAFF TEE WHITE[B]
60244 acOlaSia I DON'T GIVE A SHIT TEE WHITE
60248 acOlaSia NEXT IS YOU TEE WHITE
63235 acOlaSia (アコレイジア) Hungry L/S WHITE
57188 acOlaSia SMILE MOON BEANIE WHITE
57193 acOlaSia LOGO BEANIE WHITE
54731 acOlaSia “EXIT” big tee White
54733 acOlaSia “KILL NOTICE” big tee White
60240 acOlaSia VICTIM TEE WHITE
60242 acOlaSia FRIDAY BACK PRINT TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
55998 acOlaSia LOSING MY MIND TEE WHITE
56000 acOlaSia MARLBONALD TEE WHITE
56085 acOlaSia SKULL SKATE tee white
69167 acOlaSia (アコレイジア)Melancholy Twins tee White
69169 acOlaSia (アコレイジア)Thanatos tee White
56601 acOlaSia HOMINIDAE L/S WHITE
56603 acOlaSia INSANE L/S WHITE
57186 acOlaSia 煙仄 L/S WHITE
65931 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -100g- WHITE
65934 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -12g- WHITE
69373 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT BLUE
69374 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT RED
57183 acOlaSia STAFF L/S WHITE
56606 acOlaSia MAD DOG PULLOVER WHITE