SQL
AخA
SELECT DISTINCT p.page_namespace, p.page_title, gt.gt_lat, gt.gt_lon
FROM page p
JOIN geo_tags gt
ON p.page_id = gt.gt_page_id
WHERE gt.gt_globe = 'earth'
AND p.page_namespace = 0
AND p.page_title REGEXP '^[Z]';
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.