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 20:53:36')
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
25351 PARADOX SHINTO COAT BLACK
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
28630 PARADOX - SKINNY PANTS BLACK
28631 PARADOX - BORDER L/S TEE (BLACK)
28632 PARADOX - BORDER L/S TEE (RED)
28633 PARADOX - BORDER L/S TEE (WHITE)
28945 PARADOX - CACHECOEUR (BLACK)
28946 PARADOX - MINIMAL MA1 (BLK)
29022 PARADOX - GRAPHIC BIG TEE BANDANNA
29102 PARADOX - PILE SOCKS (LAZOR)
29103 PARADOX - GRAPHIC WIDE ZIP PARKA (MAGIC)
29104 PARADOX - GRAPHIC WIDE ZIP PARKA (BANDANNA)
29105 PARADOX - WIDE ZIP PARKA (BLACK)
29857 PARADOX PILE SOCKS (LAZOR)