use enwiki_p;

​

select count(*), redirect_counts.count as redirect_count as count from (

  select count(*) as count from redirect

  join page on page_id = rd_from

  where rd_namespace = 0

  and page_namespace = 0

  group by rd_title

  limit 10) redirect_counts

 group by redirect_counts.count;