Accessori tendalini, capottine

SELECT pro_id, pro_nome, pro_ordine, pro_stato, MIN(sku_vendita) AS min, MAX(sku_vendita) as MAX, (sku_listino - sku_vendita) AS diff , url_seo FROM catalogo_prodotti LEFT JOIN catalogo_sku ON pro_id = sku_prodotto LEFT JOIN catalogo_categorie ON pro_categoria = cat_id LEFT JOIN pagine_url ON pro_id = url_rif WHERE pro_id IN (2088,2090,2093,2094,2095,2096,2098,2101,2102,2103,2105,2107,2108,2109,2110,2121,3744,3745,3746,7573,4270,6892,6893,6894,7759,7760,8079,8080,8081,8082,8369) GROUP BY pro_id ORDER BY pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 0,24

---

SELECT pro_id AS proid FROM catalogo_prodotti LEFT JOIN catalogo_sku ON pro_id = sku_prodotto LEFT JOIN catalogo_categorie ON pro_categoria = cat_id LEFT JOIN pagine_url ON pro_id = url_rif WHERE (cat_id = 98 OR cat_madre = 98) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id