Untitled query #87618

SQL

USE commonswiki_p;
SELECT /* SLOW_OK */ concat("File:", page_title)
FROM page
WHERE page_namespace = 6       -- files only
AND page_is_redirect = 0       -- no redirects
AND page_title NOT LIKE "%/%"  -- no sub-pages
AND NOT EXISTS (
    SELECT 1
    FROM templatelinks
    WHERE tl_from = page_id 
    AND tl_title IN ("License_template_tag", "Deletion_template_tag") -- files without a license or deletion tag
)
AND NOT EXISTS ( -- files not in "No license" categories
    SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id 
    AND cl_to IN ("Media_without_a_license:_needs_history_check", "New_uploads_without_a_license")
);
SQL

Checking query status...
