Links to nonexistent "Wiktionary:Word of the day/Archive" pages

SQL

use enwiktionary_p;

select concat("Wiktionary:", pl_title) as target, group_concat(source_page.page_title separator ", ") as sources from pagelinks
left join page source_page on source_page.page_id = pl_from
left join page target_page on target_page.page_namespace = pl_namespace and target_page.page_title = pl_title
where (pl_from_namespace = 0 or pl_from_namespace = 118)
and pl_namespace = 4 and pl_title like "%Word_of_the_day\/Archive%"
and target_page.page_id is NULL
group by pl_title
limit 10;

SQL

Checking query status...