Attrezzatura

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 (8026,2527,211,212,213,214,215,216,217,218,219,220,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,5531,5529,460,461,462,463,464,465,466,467,468,469,470,471,472,473,511,513,514,515,516,590,591,592,593,594,595,596,7861,4534,4533,4373,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1226,1227,7594,3876,1387,1388,1389,1390,1391,1392,1393,1394,1396,1715,12,3321,2046,2047,2048,2049,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2077,2084,2086,2087,2125,2126,2248,2249,2250,2251,2253,2254,2255,2256,2258,2259,2260,7370,2526,2952,3173,3174,3175,8027,8028,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3394,3395,3396,3397,3398,3399,3400,3401,3809,5991,3877,3878,3879,3880,3881,3882,3883,3884,3886,3887,3888,3889,3890,3891,3892,3893,3894,3895,3896,3897,3898,3899,3900,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911,3912,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3924,3925,3926,3928,3929,3930,3931,3932,3933,3934,3935,3936,3937,3938,3939,3940,3941,3942,3943,3944,3945,3946,3947,3948,3949,3950,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,4027,4034,4035,4036,4037,4038,4039,4040,4041,4042,4043,4044,4045,4046,4047,4048,4049,4058,4060,4068,4069,4070,4071,4072,4073,4074,4075,4076,4098,4102,4103,4104,4105,4106,4108,4165,4166,4252,4253,4254,4255,4256,4257,4258,4259,4260,4261,4262,4263,4264,4265,4266,4267,4268,4269,4385,4387,4389,4535,4536,4537,4538,4539,4540,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5105,5106,5107,5108,5109,5110,5111,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5125,5126,5127,5128,5129,5130,5131,5135,5136,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,5164,5165,5166,5167,5168,5169,5170,5171,5172,5193,5194,5195,5196,5197,5198,5199,5201,5202,5203,5204,5205,5206,5207,5208,5209,5210,5211,5212,5213,5214,5222,5216,5217,5218,5219,5220,5221,5223,5224,5225,5226,5227,5228,5229,5230,5231,5232,5233,5234,5235,5236,5237,5238,5239,5240,5241,5242,5243,5244,5245,5246,5247,5248,5249,5250,5251,5252,5253,5254,5438,5440,5532,5533,5534,5536,5537,5539,5540,5555,5556,5557,5558,5559,5560,5561,8850,8849,5563,5564,5565,5566,5567,5568,5569,5570,5571,5572,5573,5574,5575,5576,5577,8852,8851,5579,5581,5582,5583,5584,5585,5586,5587,5588,5589,5590,5591,5592,5593,5594,5595,5596,5597,5598,5599,5600,5601,5602,5603,5604,5605,5617,5747,5748,5749,5876,5966,9019,5992,5995,6012,6013,6019,6033,6034,6036,6127,6128,6155,6156,6162,6164,6165,6166,6167,8144,6444,6526,6527,6528,6529,6530,6531,6532,6891,7120,7172,7178,7179,7482,7369,7365,7371,7551,7552,7553,7554,7555,7556,7577,7578,7579,7580,7584,7585,7586,7587,7588,7644,7645,7865,7699,7710,7711,7712,7713,7844,7845,7866,8216,7900,7903,7904,7905,7906,7912,8116,8117,8118,8184,8185,8186,8242,8243,8244,8245,8246,8247,8248,8249,8250,8251,8252,8253,8254,8255,8320,8321,8327,8328,8329,8330,8331,8332,8333,8334,8335,8336,8337,8338,8339,8340,8341,8342,8343,8344,8345,8346,8347,8348,8352,8353,8354,8355,8356,8357,8358,8364,8365,8366,8367,8409,8536,8537,8538,8539,8540,8541,8847,8848,8887,8888,8889,8890,8891,8892,8893,8952,9103) GROUP BY pro_id ORDER BY diff DESC, pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 144,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 = 6 OR cat_madre = 6) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id