Mainspace redirect count leaderboard

SQL

-- Generated from siteinfo-namespaces in the dump;
-- namespaces.name is the local name, not the canonical name.
with namespaces(id, name) as (
values
    (-2, 'Media'),
    (-1, 'Special'),
    (0, ''),
    (1, 'Talk'),
    (2, 'User'),
    (3, 'User talk'),
    (4, 'Wikipedia'),
    (5, 'Wikipedia talk'),
    (6, 'File'),
    (7, 'File talk'),
    (8, 'MediaWiki'),
    (9, 'MediaWiki talk'),
    (10, 'Template'),
    (11, 'Template talk'),
    (12, 'Help'),
    (13, 'Help talk'),
    (14, 'Category'),
    (15, 'Category talk'),
    (100, 'Portal'),
    (101, 'Portal talk'),
    (108, 'Book'),
    (109, 'Book talk'),
    (118, 'Draft'),
    (119, 'Draft talk'),
    (710, 'TimedText'),
    (711, 'TimedText talk'),
    (828, 'Module'),
    (829, 'Module talk'),
    (2300, 'Gadget'),
    (2301, 'Gadget talk'),
    (2302, 'Gadget definition'),
    (2303, 'Gadget definition talk')
)
select
    replace(concat(
        if(namespaces.name = '', '', concat(namespaces.name, ':')),
        `redirect title`
    ), '_', ' ') as `redirect target`,
    `count` as `redirect count`,
    `redirect namespace`,
    `redirect title`
from
  (
    select
      count(rd_from) as `count`, rd_title as `redirect title`, rd_namespace as `redirect namespace`
    from
      redirect
   	where
      rd_namespace = 0
    group by
      rd_title
  ) redirect_counts
join namespaces on namespaces.id = `redirect namespace`
where `count` >= 200
order by
  `count` desc;
SQL

Checking query status...
