Pompe sentina, autoclavi

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 (1142,1143,1726,1727,1728,1732,1734,1735,1743,1746,1749,1752,1756,1757,1761,1766,1767,1768,1771,1772,1773,1774,1775,1779,1780,1781,1788,1789,1791,1799,1800,1801,1803,1805,1808,1812,1814,1823,1824,1825,1827,1828,1888,1889,1890,1891,1912,1915,1917,1919,1920,1921,1922,1924,2390,2391,3291,4530,4523,4529,4874,1923,7389,7390,7391,7402,7403,7404,7405,7668,7772,7773,7774,7775,8473,8474,8476,8477,8478,8479,8480,8481,8482,8483,8484,8485,8486,8487,8488,8489,8490,8492,8493,8494,8495,8501,8503,8504,8505,8509,8510,8512,8530,9063) 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 = 88 OR cat_madre = 88) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id