SQL
x
USE commonswiki_p;
SELECT page_title
FROM geo_tags
INNER JOIN page
ON page_id = gt_page_id
JOIN (
SELECT rev_timestamp,
rev_page
FROM revision
WHERE rev_timestamp >= "20200308") 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 > 60
AND gt_lat < 70
AND gt_lon > 22
AND gt_lon < 27
AND page_namespace = 6
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.