perdón, me lo había comido:
Código:
(SELECT country, COUNT(*) AS total FROM provider_id GROUP by country ORDER BY total DESC Limit 5 )
union
(
select 'otros' as country, count(*) as total from provider_id PI where
(select count(*) from provider_id where country=PI.country)<
(select count(*) as total from provider_id group by country order by total desc limit 1 offset 5)
)