Commons files to add to Media_with_geo-coordinates_needing_categories

SQL

USE commonswiki_p;
SELECT concat("File:",page_title) as pagename
/*SELECT count(*)*/
FROM 
  page
  INNER JOIN templatelinks t1 ON t1.tl_from = page_id and t1.tl_title = 'Uncategorized' -- files transcluding {{Uncategorized}}
  /*INNER JOIN categorylinks c1  ON c1.cl_from = page_id and c1.cl_to = "All_media_needing_categories_as_of_2015"*/ -- files in All media needing categories as of 2015 category
  /*INNER JOIN templatelinks t2 ON t2.tl_from = page_id AND t2.tl_title = 'Location' -- files transcluding {{Location}}*/
  INNER JOIN categorylinks c2  ON c2.cl_from = page_id and c2.cl_to = "Media_with_locations" -- files in Media_with_locations category
WHERE
  page_namespace = 6 and       -- files only
  not exists ( -- file not already in "Media_with_geo-coordinates_needing_categories" 
    select * 
    from categorylinks
    where 
      cl_from=page_id and 
      cl_to = "Media_with_geo-coordinates_needing_categories"
    limit 1 
  )
SQL

Checking query status...
