use enwiki_p;

​

select count(*) as pages, redirect_counts.count as `redirect count` from (

  select count(*) as count from page

  join redirect on rd_namespace = page_namespace and rd_title = page_title

  where rd_namespace = 0

  and page_namespace = 0

  group by page_namespace, page_title

  limit 1000) redirect_counts

 group by redirect_counts.count;