Untitled query #81455

SQL

-- USE commonswiki_p;
SELECT CONCAT("File:", page_title)
FROM page p
LEFT JOIN templatelinks tl ON tl.tl_from = p.page_id AND tl.tl_namespace IN (10, 2) AND tl.tl_title IN ("License_template_tag", "Deletion_template_tag")
LEFT JOIN categorylinks cl ON cl.cl_from = p.page_id AND cl.cl_to IN ("Media_without_a_license:_needs_history_check", "New_uploads_without_a_license")
WHERE p.page_namespace = 6       -- files only
AND p.page_is_redirect = 0       -- no redirects
AND NOT p.page_title LIKE "%/%"  -- no sub-pages
AND tl.tl_from IS NULL           -- no matching template links found
AND cl.cl_from IS NULL           -- no matching category links found
SQL

Checking query status...
