SQL
x
select gt_lat, gt_lon, abs(gt_lat) as gt_lat_abs, abs(gt_lon) as gt_lon_abs, gt_primary, gt_page_id, gt_name,
(select page_namespace from page where page_id = gt_page_id) as ns,
(select page_title from page where page_id = gt_page_id) as title,
gt_country,gt_region from geo_tags
having (gt_lat_abs = gt_lon_abs) and (ns in (0,6,14))
limit 500;
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.