This query is marked as a draft This query has been published by Erutuon.

SQL

x
 
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...