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 22:24:36')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 25
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
18447 Subciety GLORIOUS S/S - BLACK/WHITE
56385 Subciety (サブサエティ) BEANIE-SERVER - BLACK
64197 Subciety (サブサエティ) GLORIOUS S/S BLACK
69254 Subciety (サブサエティ) LOW WATCH BLACK
70286 Subciety(サブサエティ)MESH CAP-Hard Days- BLACK
67784 Subciety (サブサエティ) SHOULDER BAG PURPLE
70287 Subciety(サブサエティ)LOW CROWN SNAPBACK CAP BLACK/WHITE
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
23090 Subciety(サブサエティ) THRON S/S BLACK
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
67922 【BanG Dream! ×ゲキクロ 2023 ver.】氷川紗夜×Subciety コラボ Tシャツ
57913 Subciety (サブサエティ) DRUNKER S/S- BLACK
59304 Subciety (サブサエティ) CROWD S/S BLACK
64310 Subciety (サブサエティ) LEAGUE TEE BLACK/YELLOW
64313 Subciety (サブサエティ) Monogram TEE BLACK
64316 Subciety (サブサエティ) SUPPORTER TEE BLACK
64317 Subciety (サブサエティ) FLOCKS CAP BLACK
65335 Subciety (サブサエティ) LIBIDOS TEE BLACK
65522 Subciety (サブサエティ) FUR HAT BLACK
65524 Subciety (サブサエティ) WOOL HUNTING BLACK
68115 Subciety (サブサエティ) CREST TEE BLACK
68165 Subciety (サブサエティ)Butterfly TEE BLACK
69192 Subciety (サブサエティ) CROWD RAGLAN L/S BLACK