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,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,6316,1739,1740,1741,1742,1743,1744,1745,1746,1747,1749,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1796,1797,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1912,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,2390,2391,3291,4475,4476,4478,4479,4480,4481,4482,4483,4484,4485,4486,4487,4488,4489,4490,4491,4530,4523,4529,4874,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