Untitled query #85991

SQL

SELECT /* SLOW_OK */ concat("File:", page_title) AS file_name
FROM page
WHERE page_namespace = 6          -- Files only
  AND page_is_redirect = 0        -- No redirects
  AND NOT page_title LIKE "%/%"   -- No sub-pages
  AND NOT EXISTS (
    SELECT 1
    FROM templatelinks
    WHERE tl_from = page_id
      AND tl_namespace IN (10, 2) -- Namespace for templates and categories
      AND tl_title IN ("License_template_tag", "Deletion_template_tag")
    LIMIT 1
  )
  AND NOT EXISTS (
    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")
    LIMIT 1
  );
SQL

Checking query status...
