Untitled query #6476

SQL

USE eswiki_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','Biohist', 'BANQ_media') 
  AND tl_namespace = 10 
)
AND NOT EXISTS ( 
  SELECT * 
  FROM categorylinks 
  WHERE page_id = cl_from 
  AND cl_to IN ("Wikiviajes_por_Venezuela_2014")
)
LIMIT 10000
SQL

Checking query status...
