Untitled query #18915

SQL

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 = 'Non-free_images_for_NFUR_review'
# 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',
                                             # Special cases
                                             'All_free_in_US_media')
WHERE t.tl_from IS NULL
AND p.page_namespace = 6
AND p.page_len < 270
SQL

Checking query status...
