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 =588
)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-28 23:52:15')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 447)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 25
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
57102 Zephyren 2021 NEW YEAR BAG
55039 Zephyren(ゼファレン)FUR PARKA WHITE
55040 Zephyren(ゼファレン)FUR PARKA BLACK
27110 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA BLACK
27111 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA GREEN
22644 Zephyren (ゼファレン) CROSS PAISLEY PARKA BLACK x WHITE
70905 優里xZEPHYREN -Betelgeuse- PARKA BEIGE
70906 優里xZEPHYREN -Betelgeuse- PARKA BLACK
70907 優里xZEPHYREN -Betelgeuse- PARKA GRAY
45810 Zephyren(ゼファレン)RAINBOW BIG PARKA WHITE
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66494 10-FEET×Zephyren(ゼファレン) BIG PARKA BlackxBlack
66495 10-FEET×Zephyren(ゼファレン) BIG PARKA GRAY
66496 10-FEET×Zephyren(ゼファレン) BIG PARKA OFF WHITE
19408 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - NAVY
50376 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK
50384 Zephyren(ゼファレン) DOLMAN BIG PARKA WHITE
50386 Zephyren(ゼファレン) TAPE BIG PARKA NAVY
50387 Zephyren(ゼファレン) TAPE BIG PARKA WHITE
51868 Zephyren(ゼファレン) SWITCHING PARKA BLACK / WHITE
51869 Zephyren(ゼファレン) SWITCHING PARKA NAVY / RED
55015 Zephyren(ゼファレン)LINE PARKA - Resolve - BLACK
55017 Zephyren(ゼファレン)LINE PARKA - Resolve - MUSTARD