Untitled query #6029

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 = 'Images_of_video_covers'
# 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 t.tl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
