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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)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-26 00:27:35')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 491)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
27511 PARADOX GRAPHIC BIG TEE VORTEX
27513 PARADOX - GRAPHIC BIG TEE VISION
27785 【予約商品】PARADOX GRAPHIC BIG TEE BASTARD
28100 PARADOX GRAPHIC BIG TEE HIDEOUT
28101 PARADOX GRAPHIC BIG TEE MAD
28103 PARADOX GRAPHIC BIG TEE STELLA
28104 PARADOX GRAPHIC BIG TEE HORIZON
28105 PARADOX GRAPHIC BIG TEE PUNK
28106 PARADOX GRAPHIC BIG TEE GLITCH
28107 PARADOX GRAPHIC BIG TEE ARTEMIS
28626 PARADOX - GRAPHIC BIG TEE NEWWORLD
28628 PARADOX - GRAPHIC BIG TEE BIRTH
29022 PARADOX - GRAPHIC BIG TEE BANDANNA
29864 PARADOX MINIMAL BIG TEE WHITE
29865 PARADOX MINIMAL BIG TEE BLACK
32540 PARADOX BIG TEE EXPLOSION
32541 PARADOX BIG TEE VOID
33980 PARADOX - BIG TEE (DEEP-FOREST)
33982 PARADOX - BIG TEE (MIRAGE)
33983 PARADOX - BIG TEE (ESCHATOLOGY)
34239 PARADOX - PONCHO BIG TEE (TEAR)
34240 PARADOX - BIG TEE (DIVINE)
34241 PARADOX - BIG TEE (SPIRIT)
34242 PARADOX - BIG TEE (NYX-HMR)
34243 PARADOX - BIG TEE (UNION)