Gonfiabili da traino

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 (1535,1504,1505,1506,1507,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1536,1537,1538,1539,1540,1541,1542,1543,1551,1552,1553,1554,1555,1557,6265,6266,6267,6269,6270,7250,7510,7800,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886) GROUP BY pro_id ORDER BY sku_vendita ASC, pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 72,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 = 75 AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id