Vela e sport

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 (2532,202,205,9121,1397,1398,1505,1506,1507,1525,1526,1527,1528,1529,1530,1531,1532,1533,1535,1540,1539,1541,1543,1536,1538,1551,1552,1553,1554,1555,1572,1573,1899,1900,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,2512,2513,2514,2516,2533,2534,2535,2536,2537,2538,2539,2542,3733,3872,3873,3874,3875,4062,4063,4064,4065,4066,8982,5406,5407,5408,5410,5411,5412,5413,5415,5416,5501,5502,5503,5504,5505,5506,5507,5508,5509,5510,5511,5512,5513,5514,5515,5516,5517,5518,5519,5520,5521,5522,5523,5524,5525,5526,9114,6176,6177,6178,6179,6180,6181,6182,6183,6184,6185,6186,6188,6265,6266,6267,6269,6270,6457,7119,7263,7250,7325,7508,1542,1537,1557,1534,7510,7512,7529,9161,8033,7776,7799,1504,7800,7801,7802,7803,9116,8056,8057,8058,8111,8113,8114,8152,6283,8182,8212,8213,8375,8855,8856,8857,8858,8859,8860,8861,8862,8863,8866,8867,8868,8869,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,9160) 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 = 9 OR cat_madre = 9) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id