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,
    source.page_namespace as link_from_namespace,
    count(*) as link_count,
    target.page_id is not null as link_target_exists
from prefixes
join pagelinks on pl_namespace = 104 /* Index */ and pl_title like concat(replace(index_prefix, ' ', '\_'), '%')
join page as source on source.page_id = pl_from
left join page as target on target.page_namespace = pl_namespace and target.page_title = pl_title
group by source.page_namespace, index_prefix, link_target_exists
order by link_count desc;

SQL

Checking query status...