English Wiktionary entries linking to nonexistent Citations page

SQL

use enwiktionary_p;

select
	source.page_title as 'from',
    concat('Citations:', pl_title) as 'to',
    if(exists(select 1
              from templatelinks
              where tl_from = source.page_id
              and tl_namespace = 10 # Template
              and tl_title = 'no_entry'),
       'yes',
       'no')
       as '{{no_entry}} present?'
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}}.
limit 10;

SQL

Checking query status...