USE enwiki_p;

SELECT 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 templatelinks t ON t.tl_from = p.page_id

                          AND t.tl_namespace = 10

                          AND t.tl_title IN ('Non-free_use_rationale', 

                                             'Non-free_use_rationale_2', 

                                             'Non-free_media_rationale',

                                             # Also exclude various deletion processes:

                                             'Ffd', 

                                             'Puf', 

                                             'Deletable_file', 

                                             'Now_Commons',

                                             # Also exclude files with disputed copyright status:

                                             'NFUR_not_needed')

WHERE t.tl_from IS NULL

AND p.page_namespace = 6

​

​