Untitled query #31001

Fork of Untitled query #29748 by ShakespeareFan00

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

SQL

USE enwiki_p;
SELECT p.page_latest, p.page_id, p.page_len, CONCAT("File:",p.page_title) as page_title FROM page p 
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to =  'Files_with_no_machine-readable_source'
LEFT JOIN categorylinks c2 ON cnot.cl_from = p.page_id AND cnot.cl_to
IN ('All_non-free_media', 
    'Redirects_from_moves',
   )
LEFT JOIN templatelinks t ON t.tl_from = p.page_id
                          AND t.tl_namespace = 10
                          AND t.tl_title IN (
                        # Also exclude various deletion processes:
                  'Information'
                          ) 
WHERE t.tl_from IS NULL
AND cnot.cl_from IS NULL
AND p.page_namespace = 6

SQL

Checking query status...