Untitled query #6203

SQL

use commonswiki_p;
SELECT concat("M",page_id) AS MID, 
    page_links_updated, page_touched, rev_timestamp,
    CONCAT("File:",page_title)
FROM page
#JOIN externallinks ON page_id = el_from AND  el_to LIKE '//tools.wmflabs.org/geohack/geohack.php%'
#JOIN categorylinks cl2 ON cl2.cl_from = page_id AND cl2.cl_to='Climbing_photographs_by_Jarek_Tuszyński' 
JOIN revision  ON rev_page = page_id and rev_actor=695 
#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" 

#JOIN revision  ON rev_id = page_latest and rev_actor=695 
WHERE page_namespace = 6
  AND rev_timestamp>20200000000000
  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...
