Kangxi radicals

SQL

/*
select page_title, rd_title from page
left join redirect on rd_from = page_id and rd_namespace = 0
where page_namespace = 0 and page_is_redirect = 1 and rd_title rlike '^Radical_\\d+$'
and page_title rlike '^\\p{Han}+$' collate utf8_general_ci and page_id not in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget
    where lt_title = 'R_from_Unicode_character' and lt_namespace = 10
  )
)
*/

select page_title, rd_title from page
left join redirect on rd_from = page_id and rd_namespace = 0
where page_namespace = 0 and page_is_redirect = 1 and rd_title not rlike '^Radical_\\d+$'
and page_title rlike '^\\p{Han}$' collate utf8_general_ci
SQL

Checking query status...
