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 17:40:07')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 805)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 180, 180
62020 glamb (グラム) Old School Pile Shorts - Green
63889 glamb (グラム) Old School Pile Jersey Pants - Green
61944 glamb (グラム) Paisley Pajamas SH - Black
61945 glamb (グラム) Paisley Pajamas SH - White
61989 glamb (グラム) Classic Jersey Pants - Wine
61867 glamb (グラム) Military Remake CS - White×Khaki
61481 glamb (グラム) Old School Jersey BROWN
61494 glamb (グラム) Old School Jersey Pants BLUE
61495 glamb (グラム) Old School Jersey Pants BROWN
61489 glamb (グラム) Openwork Cardgian GREEN
61482 glamb (グラム) Cactus Print Raglan CS BLACK
61483 glamb (グラム) Cactus Print Raglan CS GREEN
61436 glamb (グラム)×攻殻機動隊 SAC_2045 T White
61437 glamb (グラム)×攻殻機動隊 SAC_2045 T Black
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
61442 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Blue
61443 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Black
61490 glamb (グラム) Semi Flare Slacks BLACK
61492 glamb (グラム) Semi Flare Slacks BROWN