Commons files to add to "Media_missing_infobox_template" category

SQL

/* Commons files without an infobox and not in "Media_missing_infobox_template" Category */
use commonswiki_p;

select /* SLOW_OK */ page_title 
from page p1
where 
  p1.page_namespace=6 and          -- files only
  p1.page_is_redirect=0 and        -- no redirects
  p1.page_title not like "%/%" and -- skip rare image subpages 
  not exists ( -- file does not transclude "Information" or "Infobox_template_tag" template
    select * 
    from templatelinks 
    where 
      tl_from = p1.page_id and 
      tl_namespace=10 and 
      tl_title in ("Information","Infobox_template_tag") -- all official infoboxes (except "information") use empty "Infobox_template_tag" template
    limit 1 
  ) and
  not exists ( -- file not already in "Media_missing_infobox_template" or subcategories
    select * 
    from categorylinks c1
    where 
      c1.cl_from=page_id and 
      c1.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 1 
  )
SQL

Checking query status...
