Materiale elettrico

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 (1251,1252,1253,1254,1255,1256,1257,1258,1259,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1281,1282,1283,1284,1285,1287,1288,1289,1290,1291,1292,1293,1295,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1317,1319,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1362,1363,1364,1365,1366,1368,1369,1370,1372,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,9077,9078,3863,3864,3865,3866,3867,3868,3869,3870,3871,4084,4085,4087,4088,4124,4125,4126,4127,4128,4129,4130,4131,4132,4133,4134,4135,4136,4137,4138,4139,4140,4141,4142,4143,4144,4145,4146,4147,4148,4149,4150,4151,4152,4153,4154,4155,4156,4157,4158,4159,4160,4161,4162,4163,4164,4167,4168,4169,4170,4172,4173,4175,4176,4177,4178,4179,4180,4181,4182,4183,4184,4185,4186,4188,4189,4190,4191,4192,4193,4194,4195,4196,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4377,4378,4379,4380,4381,4382,4383,4384,4386,4388,4390,4391,4392,4393,4394,4395,4396,4397,4398,4399,4400,4401,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,5441,5528,6145,6146,6147,6148,6237,6276,6277,6284,6285,6286,6288,6291,6292,6293,6294,6295,6296,6298,6299,6300,6304,6305,6306,6307,6337,6338,6339,6391,6713,6716,6737,6749,6792,6793,6828,6829,6830,6832,6833,6834,6836,6838,6839,6840,6841,6844,6845,7366,7367,7368,7720,7721,7497,7506,7507,7537,7572,7700,7752,7809,7810,7811,7813,7974,7975,7976,7977,7978,7979,7980,7981,7982,7983,8673,9120) 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 = 59 AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id