Fari, plafoniere

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 (1237,4271,1239,1240,1241,1242,1243,1245,1246,1247,1248,1249,1250,2953,2954,2955,2956,2957,2958,2960,2961,2962,2963,2964,2968,2969,2970,2971,2972,2974,2975,2976,2977,2978,2985,2986,2987,2988,2989,2990,2991,2992,2993,2994,2995,2998,2997,2999,3000,3001,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3104,3105,3106,3107,3110,3111,3112,3113,3114,3116,3118,3119,3120,3121,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3143,3144,3720,3722,3723,5673,5674,5675,5676,5677,7832,5695,6055,6056,6057,6058,6091,6264,6317,6318,6673,6674,6675,6676,6677,6678,6680,7315,7316,7317,7318,7481,9171,8699,8700,8701,8702,8954,8955,8956,8957) GROUP BY pro_id ORDER BY pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 120,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 = 63 OR cat_madre = 63) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id