Links to some Chinese indices on English Wiktionary

SQL

with patterns(index_title_pattern) as (
	values ('Chinese\_Cangjie%'), ('Chinese\_four\_corner%'), ('Chinese\_Zhuyin%'), ('Chinese\_radical%'), ('Chinese\_total\_strokes%'), ('Mandarin_Pinyin%'), ('Cantonese\_Jyutping%')
)
select replace(replace(index_title_pattern, '\_', ' '), '%', '') as index_prefix, page_namespace as link_from_namespace, count(*) as link_count from patterns
join pagelinks on pl_namespace = 104 /* Index */ and pl_title like index_title_pattern
join page on page_id = pl_from
group by page_namespace, index_title_pattern
order by link_count desc;

SQL

Checking query status...