SELECT SQL_CALC_FOUND_ROWS 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-19 16:07:10')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 671)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
68977 HEDWiNG (ヘドウィグ) Big Mods Coat BLACK
68978 HEDWiNG (ヘドウィグ) Big Mods Coat KHAKI
68986 HEDWiNG(ヘドウィグ) Split Zip Flannel Shirt RED
68988 HEDWiNG(ヘドウィグ) Split Zip Flannel Shirt ORANGE
68981 HEDWiNG(ヘドウィグ) Big Silhouette Logo Hoodie BLACK
68982 HEDWiNG(ヘドウィグ) Big Silhouette Logo Hoodie SMOKY GREEN
68990 HEDWiNG(ヘドウィグ) Damage Out stitch Sweat WASH GRAY
68989 HEDWiNG (ヘドウィグ) C/C Out stitch L/S T-shirt BLACK
68987 HEDWiNG (ヘドウィグ) C/C Out stitch L/S T-shirt SUMI
68985 HEDWiNG (ヘドウィグ) C/C Out stitch L/S T-shirt WHITE
68983 HEDWiNG (ヘドウィグ) Space Logo Bucket hat BLACK
68771 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
68770 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・Tシャツ PURPLE
68768 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・パーカー PINK
68463 HEDWiNG (ヘドウィグ) Vacation Cat Big Silhouette T-Shirt WHITE
68461 HEDWiNG (ヘドウィグ) Vacation Cat Big Silhouette T-Shirt BLACK
68471 HEDWiNG (ヘドウィグ) Owl U.F.O. Pick-up T-Shirt WHITE
68472 HEDWiNG (ヘドウィグ) Owl U.F.O. Pick-up T-Shirt AQUA GREEN
68470 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt WHITE
68469 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt SLATE BLUE
68468 HEDWiNG (ヘドウィグ) Chaos Smile T-Shirt LAVENDER
68467 HEDWiNG (ヘドウィグ) Chaos Smile T-Shirt BLACK
68466 HEDWiNG (ヘドウィグ) C/C Pansy Big Silhouette T-Shirt type AP
68464 HEDWiNG (ヘドウィグ) C/C Pansy Big Silhouette T-Shirt type GA
68465 HEDWiNG (ヘドウィグ) C/C Pansy Big Silhouette T-Shirt type PG