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-02 07:34:37')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.point_rate >1
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 p.update_date DESC
LIMIT 0, 25
59304 Subciety (サブサエティ) CROWD S/S BLACK
63341 Subciety (サブサエティ) BLACK PANTHER TEE BLACK
64312 Subciety (サブサエティ) Monogram TEE WHITE
64313 Subciety (サブサエティ) Monogram TEE BLACK
57279 Subciety (サブサエティ) PARKA-PROVIDENCE- NAVY
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
64317 Subciety (サブサエティ) FLOCKS CAP BLACK
64318 Subciety (サブサエティ) FLOCKS CAP NAVY
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
64315 Subciety (サブサエティ) SUPPORTER TEE GRAY
64316 Subciety (サブサエティ) SUPPORTER TEE BLACK
64309 Subciety (サブサエティ) LEAGUE TEE WHITE/BLUE
64311 Subciety (サブサエティ) LEAGUE TEE NAVY
64310 Subciety (サブサエティ) LEAGUE TEE BLACK/YELLOW
64061 Subciety (サブサエティ) HALF SLEEVE SWEAT KHAKI
64063 Subciety (サブサエティ) SWEAT SHORTS GRAY
64065 Subciety (サブサエティ) SWEAT SHORTS BLACK
64067 Subciety (サブサエティ) DENIM SHORTS BLACK
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
64198 Subciety (サブサエティ) MARIA TEE WHITE
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61838 Subciety (サブサエティ) EMBROIDERY PARKA BLACK/BLACK
61697 Subciety (サブサエティ) VELOUR RUGGER SHIRT GREEN