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