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-27 13:09:56')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 349)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 120, 120
70900 TOY MACHINE (トイマシーン) PUZZLE SS TEE BLACK
70899 TOY MACHINE (トイマシーン) PUZZLE SS TEE WHITE
71241 TOY MACHINE (トイマシーン) MARKED MONSTER EMBROIDERY SS TEE BURGANDY
71240 TOY MACHINE (トイマシーン) TRANSMISSIONATOR EMBROIDERY SS TEE F.GREEN
71238 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE BLACK
71239 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE WHITE
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
71432 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE WHITE