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 =17
)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 18:36:25')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 120, 120
69004 THRASHER 16TH-C27 PNK
3211 RUDIE'S SPARK MESH CAP BLACK/BLACK/WHITE
37316 RUDIE'S HEAD GEAR SPARK MESH CAP
66259 ANIMALIA (アニマリア) ROLL UP BEANIE BLACK
66260 ANIMALIA (アニマリア) ROLL UP BEANIE ORANGE
71316 MÅNESKIN UNISEX MESH BACK CAP: LOUD KIDS ON TOUR
64093 Meltyglow (メルティグロウ) 刺繍入り配色LOGO CAP【ORANGE×BLACK】
69476 ROLLING CRADLE (ローリングクレイドル) LOGO CAP WHITE
69945 ROLLING CRADLE (ローリングクレイドル) HEART CRADLE CAP CHARCOAL
49100 FILA FLH-P01 RED
54513 FILA TOKYO LABEL LOW CAP WHITE
54514 FILA TOKYO LABEL LOW CAP BLACK
64076 AFFECTER (アフェクター) COLLEGE LOGO CAP ORANGE
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY
64078 AFFECTER (アフェクター) COLLEGE LOGO CAP BLACK
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
27390 THRASHER 16TH-C26 WASH CAP BLACK