Fork of Transclusions of missing templates by Plastikspork
This query is marked as a draft This query has been published by EqJjgOa8rVvsRmZL.

SQL

x
 
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)
limit 100
-- 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;
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...