USE commonswiki_p;

​

SELECT DISTINCT concat("File:",page_title) 

from page, categorylinks, templatelinks 

where 

  page_namespace=6              -- files only

  AND cl_from=page_id 

  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") 

  AND tl_from = page_id 

  AND tl_namespace=10 

  AND tl_title in ('Infobox_template_tag','Information') 

LIMIT 1000

​