Untitled query #5632

SQL

USE enwiki_p;
SELECT p.page_id FROM page p
INNER JOIN categorylinks c1 ON c1.cl_from = p.page_id AND c1.cl_to = 'All_non-free_media'
# Exclude files with templated rationales as some rationale templates are very short:
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')
                          AND t.tl_title IN ('db-meta'.'Deletable_file')
LEFT JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to = 'All_Wikipedia_files_with_no_non-free_use_rationale'
WHERE p.page_len < 200
AND t.tl_from IS NULL
AND c2.cl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
