Isolanti, detergenti, vernici

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 (738,739,740,741,743,744,745,746,748,750,751,753,755,756,758,761,762,763,768,773,774,775,779,780,781,783,785,787,851,856,857,985,862,867,870,871,872,880,884,896,899,902,916,917,919,920,922,926,927,928,929,930,931,933,934,935,941,943,944,946,948,949,950,951,953,954,955,956,959,960,965,969,975,976,977,978,980,981,982,984,986,987,996,997,998,999,1000,1001,1002,1003,1005,1006,1007,1009,1010,1011,1012,1014,1015,1016,1017,1018,1019,1020,1021,1023,1130,1131,1132,1133,1716,2919,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2941,3798,3799,4375,4376,4512,4513,4514,4515,4516,4568,4567,4566,4569,4570,4571,4572,4573,4574,4872,4871,4855,4856,4857,4858,4859,4860,4861,4862,4863,4864,4865,4866,4867,4868,4869,4870,5160,5161,5163,5255,5256,5257,5258,5259,5262,5263,5264,5265,5266,5267,5268,5269,5270,5271,5272,5273,5274,5275,5276,5277,5279,5280,5281,5282,5283,5284,5285,5286,5287,5288,5289,5290,5291,5292,5293,5302,5381,5382,5383,5417,5418,5496,5545,5546,5547,5548,5549,5644,6358,6359,6360,6361,6362,6363,6364,6365,6366,6367,6368,6369,6386,7264,7265,7300,7719,7509,7691,7692,7693,7725,7726,7727,7729,7730,7731,7732,7733,7734,8180,8181,8187,8188,8189,8190,8425,8426,8427,8428,8429,8430,8431,8432,8710,8711,8712,8713) GROUP BY pro_id ORDER BY pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 0,48

---

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 = 47 AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id