Commons:Files with missing infobox template

Fork of Commons:Pages in Creator namespace without Creator template by ZI Jony

This query is marked as a draft This query has been published by ZI Jony.

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 ("Media_missing_infobox_template", 
                "Artworks_missing_infobox_template", 
                "Items_with_OTRS_permission_missing_infobox_template",
                "Pages_using_Information_template_with_parsing_errors")
)
LIMIT 10

SQL

Checking query status...