Commons files to add to "Media_missing_infobox_template" category (#2)

SQL

USE commonswiki_p;
SELECT concat("File:",page_title)
FROM page
WHERE page_namespace = 6      -- files only
AND page_is_redirect = 0      -- no redirects
AND page_title NOT LIKE '%/%' -- skip rare image subpages 
AND NOT EXISTS ( 
  SELECT * 
  FROM templatelinks 
  WHERE page_id = tl_from 
  AND tl_title in ('Infobox_template_tag','Information') 
  AND tl_namespace = 10 
)
AND NOT EXISTS ( 
  SELECT * 
  FROM categorylinks 
  WHERE page_id = cl_from 
  AND cl_to IN (
    SELECT DISTINCT p2.page_title -- subcategories of "Media_missing_infobox_template"
    FROM page p2
    INNER JOIN categorylinks c2 on c2.cl_from = p2.page_id 
    WHERE p2.page_namespace=14 
    AND (c2.cl_to = "Media_missing_infobox_template" OR p2.page_title="Media_missing_infobox_template")
  )
)
LIMIT 10000

SQL

Checking query status...