Impianti

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 (109,110,5528,438,446,447,450,451,452,458,459,7720,4377,7923,9120,1061,1062,1065,1066,1067,1068,1069,1073,1075,1076,1077,1085,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1105,1106,1107,1108,1113,1114,1115,1116,1117,1119,7533,7532,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1144,1145,1146,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,9077,1356,1357,1362,1363,1364,1365,1366,1368,1369,1370,1372,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1386,1413,1414,1471,1472,1473,1474,1475,1476,1477,1478,1479,1986,1993,1997,1998,2000,2001,2002,2003,2247,2257,2773,2774,2775,2777,2778,2779,2780,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2828,2829,2830,2831,2832,2833,2834,2835,2853,2854,3297,9078,7593,3742,3743,3751,3752,3753,3794,3863,3864,3865,3866,3867,3868,3869,3870,3871,4085,4087,4088,4132,4124,4125,4126,4127,4128,4129,4130,4131,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,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,4448,4449,4450,4451,4452,4453,4454,4455,4456,4457,4458,4459,4460,4461,4462,4463,4464,4465,4466,4467,4543,4544,4545,4546,5441,5485,5486,5487,5607,5609,7867,5967,8126,6041,8985,6145,6146,6147,6148,6237,6243,6334,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6263,6276,6277,6284,6285,6286,6288,6291,6292,6293,6294,6295,6296,6298,6299,6300,6304,6305,6306,6307,6324,6337,6338,6339,6387,6391,6409,6410,6411,6412,6413,6414,6415,6416,6417,6418,6419,6420,6421,6422,6423,6424,6425,6426,6427,6428,6429,6430,6431,6432,6433,6434,6435,6436,6437,6438,6439,6440,6713,6716,6737,6749,6792,6793,6829,6828,6830,6832,6833,6834,6836,6838,6839,6840,6841,6844,6845,7572,4084,7497,7366,7367,7368,7501,7506,7507,7537,7646,7651,7809,8125,8124,8123,8122,7685,7686,8121,7700,7721,7752,7790,7791,9079,7810,7811,7813,7841,7842,7843,7869,8225,8224,7883,7974,7975,7976,7977,7978,7979,7980,7981,7982,7983,8022,8127,8226,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8227,8228,8229,8230,8231,8232,8233,8234,8235,8236,8349,8551,8552,8553,8554,8607,8608,8609,8610,8611,8612,8673,8715,8718,8719,8720,8721,8722,8723,8724,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,8741,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757,8986,8987,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015) 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 = 4 OR cat_madre = 4) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id