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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =593
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-29 01:06:25')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 85)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
66464 ROLLING CRADLE (ローリングクレイドル) CHECK TOTE / NAVY
66461 ROLLING CRADLE (ローリングクレイドル) CHECK TOTE / YELLOW
62134 ROLLING CRADLE CIRCLE LOGO BAG GRAY
62135 ROLLING CRADLE CIRCLE LOGO BAG BLACK
59229 ROLLING CRADLE TV STATIC BAG BLACK
24207 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Orange
24209 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Blue
28542 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Blue-Orange
28543 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Yellow-Purple
28544 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Charcoal-Purple
32272 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Natural
32274 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Black
39417 ROLLING CRADLE RC CHEMICAL TOTE BAG GREEN
39418 ROLLING CRADLE RC CHEMICAL TOTE BAG RED
39419 ROLLING CRADLE RC CHECKER BANANA BAG RED
39420 ROLLING CRADLE RC CHECKER BANANA BAG BLACK
39421 ROLLING CRADLE RC CHECKER BANANA BAG NAVY
41357 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Orange
41358 ROLLING CRADLE RC QUICK POCKET POACH / Orange
41363 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Camo
41364 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Black
41365 ROLLING CRADLE RC QUICK POCKET POACH / Black
41367 ROLLING CRADLE RC QUICK POCKET POACH / Camo
41705 ROLLING CRADLE CYCLOPS CLUTCH BAG / Black
45923 ROLLING CRADLE CYCLOPS HOLIDAY SHOULDER / Black