Extracted Files with Deleted Originals

SQL

USE commonswiki_p;

SELECT 
  img.img_name AS ExtractedFile,
  tl_title AS OriginalFileTemplate,
  REPLACE(tl_title, '_', ' ') AS OriginalFileName,
  CASE
    WHEN EXISTS (
      SELECT 1 
      FROM image AS original_img 
      WHERE original_img.img_name = tl_title
    ) THEN 'Exists'
    ELSE 'Deleted'
  END AS OriginalFileStatus
FROM image AS img
JOIN templatelinks AS tl
  ON img.img_name = tl.tl_from
WHERE tl.tl_namespace = 10  -- Template namespace
  AND tl.tl_title LIKE 'Extracted_from%'
  AND NOT EXISTS (
    SELECT 1 
    FROM image AS original_img 
    WHERE original_img.img_name = tl.tl_title
  )
LIMIT 100;
SQL

Checking query status...
