Files with a single transclusion of [[template:Category_definition:_Object]]

Fork of Files_with_PermissionOTRS_template_but_without_P6305_SDC_statement by Jarekt

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

SQL

USE commonswiki_p;
select concat("Category:",cat.page_title) as pagename,  concat("File:",file.page_title) as filep
from page cat
# cat transcludes [[template:Category_definition:_Object]]
join templatelinks t2 on cat.page_id    = t2.tl_from  and t2.tl_namespace = 10  AND t2.tl_title="Category_definition:_Object" 
# cat is transcluded
join templatelinks t1 on cat.page_title = t1.tl_title and t1.tl_namespace = 14 
join page file on file.page_id = t2.tl_from and file.tl_namespace = 6
where cat.page_namespace = 14 
limit 100

SQL

Checking query status...