Extracted Files with Deleted Originals

SQL

USE commonswiki_p;

SELECT 
  img.img_name AS ExtractedFile,
  p.page_title AS DeletedOriginalFile
FROM image AS img
JOIN templatelinks AS tl
  ON img.img_name = tl.tl_from
JOIN page AS p
  ON tl.tl_target_id = p.page_id
WHERE tl.tl_from_namespace = 6  -- File namespace for extracted files
  AND p.page_namespace = 10  -- Template namespace for "Extracted from"
  AND p.page_title LIKE 'Extracted_from%'
  AND NOT EXISTS (
    SELECT 1 
    FROM image AS original_img
    WHERE original_img.img_name = p.page_title
  )
LIMIT 100;

SQL

Checking query status...