Recent geolocated files from Finland

Fork of Recent geolocated files from Finland by Antti T. Leppänen

This query is marked as a draft This query has been published by Estopedist1.

SQL

USE commonswiki_p;
SELECT CONCAT ('File:',page_title,'') AS page
AT('',plwiki_p.page.page_title,'') AS pl,
FROM geo_tags
INNER JOIN page
    ON page_id = gt_page_id
JOIN (
  SELECT rev_timestamp,
  rev_page
  FROM revision
  WHERE rev_timestamp >= "20180111") as rev
  ON rev.rev_page=page_id
  AND rev.rev_timestamp=(SELECT MIN(rev_timestamp)
                     FROM revision AS last 
                     WHERE last.rev_page = page_id)
#WHERE gt_globe = "earth"
	AND gt_lat > 57
    AND gt_lat < 60
    AND gt_lon > 21
    AND gt_lon < 29
 
    AND page_namespace = 6
LIMIT 99;

SQL

Checking query status...