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_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 = 10
and lt_title not in (select page_title from page where page_namespace = 10)
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.