Untitled query #5632

SQL

USE enwiki_p;
SELECT p.page_id,p.page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.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',
                                             # Also exclude various deletion processes:
                                             'Ffd', 'Puf', 'Deletable_file', 'Db-meta', 'Now_Commons',
                                             # Also exclude files with disputed copyright status:
                                             "NFUR_not_needed", "Wrong-license")
WHERE p.page_len < 230
AND t.tl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
