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,458,459,7720,4377,7923,1068,1075,1090,1092,1095,1100,1102,1103,1106,1122,1124,1126,1127,1129,1255,1256,1257,1258,1259,1268,1269,1270,1271,1272,1274,1275,1276,1278,1281,1283,1284,1285,1290,1291,1292,1293,1295,1312,1313,1314,1319,1325,1326,1328,1330,1334,1335,1336,1337,1340,1341,1342,1343,1344,1345,1349,1350,1351,1353,1357,1362,1363,1364,1366,1368,1370,1374,1375,1377,1381,1414,1475,1478,2247,2773,2782,2784,2785,2791,2805,2806,2808,2812,2815,2817,2818,2821,2822,2828,2829,2830,2831,2834,2835,2853,3297,7593,3742,3743,3751,3752,3753,3794,3863,3864,3865,3866,3869,4085,4132,4125,4126,4127,4128,4130,4133,4138,4140,4141,4142,4145,4147,4148,4150,4155,4156,4159,4160,4161,4162,4167,4177,4178,4183,4186,4188,4193,4384,4416,4448,4457,4458,4459,4461,4543,4544,4545,4546,7867,6041,8985,6145,6146,6147,6148,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,6410,6413,6415,6421,6422,6424,6426,6433,6713,6716,6737,6749,6792,6793,6829,6828,6830,6832,6833,6834,6836,6838,6839,6840,6841,6844,6845,7231,7497,7366,7367,7368,7501,7506,7507,7646,7651,7809,8122,7685,7686,8121,7700,7721,7790,7791,7810,7811,7813,7841,7842,7843,7869,8225,8224,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 sku_vendita ASC, pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 36,12

---

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