Links to some Chinese indices on English Wiktionary

SQL

with prefixes(index_prefix) as (
	values ('Chinese Cangjie'), ('Chinese four corner'), ('Chinese Zhuyin'), ('Chinese radical'), ('Chinese total strokes'), ('Mandarin Pinyin'), ('Cantonese Jyutping')
)
select 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 concat(replace(index_prefix, ' ', '\_'), '%')
join page on page_id = pl_from
group by page_namespace, index_title_pattern
order by link_count desc;

SQL

Checking query status...