English Wiktionary entries linking to nonexistent Citations page

SQL

use enwiktionary_p;

select source.page_title as 'from', concat('Citations:', target.page_title) as 'to'
from pagelinks
join page source on source.page_id = pl_from
left join page target on target.page_title = pl_title and target.page_namespace = pl_namespace
where pl_from_namespace = 0
	and pl_namespace = 114 # Citations
    and target.page_id is NULL
    # Exclude cases where the link is probably generated by {{no entry}}
    # (assuming the citation page is not linked both inside and outside of {{no entry}}.
    and not exists(select 1
                   from templatelinks
                   where tl_from = source.page_id
                   and tl_namespace = 10 # Template
                   and tl_title = 'no_entry')
limit 10;

SQL

Checking query status...