SQL
AخA
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.