Files with & without certain templates

SQL

SELECT page_id FROM page
JOIN categorylinks ON cl_from = page_id AND cl_to IN
   ('Copyright_holder_released_public_domain_files', 'PD_other_reasons', 'Files_from_freely_licensed_external_sources',
    'Files_licensed_by_third_parties')
LEFT JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title IN
   ('Ffd', 'Deletable_file', 'OTRS_pending', 'OTRS_received', 'OTRS_permission')
WHERE tl_from IS NULL

AخA
 
SELECT page_id FROM pageJOIN categorylinks ON cl_from = page_id AND cl_to IN   ('Copyright_holder_released_public_domain_files', 'PD_other_reasons', 'Files_from_freely_licensed_external_sources',    'Files_licensed_by_third_parties')LEFT JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title IN   ('Ffd', 'Deletable_file', 'OTRS_pending', 'OTRS_received', 'OTRS_permission')WHERE tl_from IS NULL

SQL

Checking query status...