Transclusions of missing templatelinks

Fork of Transclusions of missing templates by Plastikspork

This query is marked as a draft This query has been published by EqJjgOa8rVvsRmZL.

SQL

select page_namespace, page_title, lt_namespace, lt_title from linktarget
join templatelinks on tl_target_id = lt_id
join page on tl_from = page_id and page_namespace % 2 = 0 and page_namespace != 2
where lt_namespace in (10, 828)
and lt_title not in (select page_title from page where page_namespace = lt_namespace)
and lt_title not rlike '/doc$|^Road_data/|^Signpost/index/|^Transclusion_count/data/|^Country_data_Xanadu$'
and page_title not like 'Sandbox/%'
-- order by page_namespace

/*
select page_title, pl_title from pagelinks
join page on pl_from = page_id and page_namespace = 0
where pl_namespace = 10
and pl_title not in (select page_title from page where page_namespace = 10)
limit 100;
*/

SQL

Checking query status...