Files_with_PermissionOTRS_template_but_without_P6305_SDC_statement

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:",page_title), page_links_updated, page_touched
FROM page
JOIN categorylinks c1 ON page_id=c1.cl_from AND c1.cl_to='Items_with_OTRS_permission_confirmed'
join templatelinks on page_id=tl_from and tl_namespace = 10  AND (tl_title="PermissionOTRS" OR tl_title="OTRS")
WHERE 
  page_namespace = 6 
  AND NOT page_id IN (
    SELECT c2.cl_from 
    FROM categorylinks c2
    WHERE c2.cl_to in ( "P6305_SDC", 'Files_with_PermissionOTRS_template_but_without_P6305_SDC_statement' )
  )
limit 100

SQL

Checking query status...