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("File:",file.page_title) as filep #, concat("Category:",t3.tl_title) as pagename,  
from page file
join templatelinks t3 on file.page_id = t3.tl_from and t3.tl_namespace = 14 
where file.page_namespace = 6 
AND t3.tl_title IN (
	select cat.page_title
	from page cat
	join templatelinks t1 on t1.tl_namespace = 14  AND t1.tl_title=cat.page_title
	join templatelinks t2 on t2.tl_namespace = 10  AND t2.tl_title="Category_definition:_Object" and cat.page_id = t2.tl_from 
	AND page_namespace = 14 
	group by cat.page_id
  	having count(*)=2
)
limit 10000

SQL

Checking query status...