Untitled query #88069

SQL

SELECT page_title
FROM page
WHERE page_namespace = 6
AND page_is_redirect = 0
AND NOT EXISTS (
  SELECT 1
  FROM imagelinks
  WHERE imagelinks.il_to = page.page_title
)
AND NOT EXISTS (
  SELECT 1
  FROM templatelinks
  JOIN page AS template_page ON template_page.page_id = templatelinks.tl_target_id
  WHERE templatelinks.tl_from = page.page_id
    AND templatelinks.tl_from_namespace = 6
    AND template_page.page_title = "Template:Orphan file"
)
AND EXISTS (
  SELECT 1
  FROM categorylinks
  WHERE categorylinks.cl_from = page.page_id
    AND categorylinks.cl_to = "All_free_media"
)
ORDER BY page.page_id ASC;
SQL

Checking query status...
