Docce e box docce

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 (1384,1385,3178,1999,2244,2245,2246,2917,2918,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,4280,4281,4282,4283,4284,4285,4286,4431,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4442,4443,5401,6975,6937,6938,6974,6973,6971,6942,6943,6944,6945,6946,6947,6948,6949,6950,6951,6952,6953,6954,6955,6956,6957,6958,6959,6960,6961,6962,6963,6964,6965,6966,6967,6968,6976,8475,8631) GROUP BY pro_id ORDER BY pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 72,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 = 64 OR cat_madre = 64) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id