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-04-30 20:52:13')
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 100, 25
70748 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA GRAY
70746 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA BLACK
70743 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY TEE WHITE
70741 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY TEE BLACK
70739 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY SWEAT WHITE
70740 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY SWEAT GRAY
70738 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY SWEAT BLACK
70745 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE WHITE
70750 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE WHITE/PURPLE
70747 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE WHITE/BLACK
68451 Subciety (サブサエティ) CROWD S/S GRAY
67447 Subciety (サブサエティ) COFFEE SHOP TEE BLACK
70289 Subciety(サブサエティ)PROVIDENCE ZIP PARKA BLACK
70824 Subciety(サブサエティ)WAFFLE ZIP PARKA BLACK
70825 Subciety(サブサエティ)WAFFLE PANTS BLACK
70475 Subciety(サブサエティ) DAMAGED SWEAT BLACK
70477 Subciety(サブサエティ) DAMAGED SWEAT NAVY
70476 Subciety(サブサエティ) DAMAGED SWEAT GRAY
70774 Subciety (サブサエティ) FLOWER PAISLEY BODY BAG BLACK
70742 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE BLACK
70749 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE BLACK
70292 Subciety(サブサエティ)SUNGLASS -ACKBAR- BLACK/BLACK
69970 Subciety (サブサエティ) GIANT SIZE PARKA MUSTARD
69969 Subciety (サブサエティ) GIANT SIZE PARKA BLACK
69966 Subciety (サブサエティ) SNOW CARGO PANTS BLACK