Fork of
Potentiell falsche Koordinaten in Bayern
by Thgoiter
This query is marked as a draft
This query has been published
by Erell.
SQL
AخA
use dewiki_p;
select abs(gt_lat - cen_gt_lat + gt_lon - cen_gt_lon) as distanzungefaehr,
gt_lat, gt_lon, gt_page_id, gt_name,
(select page_title from page where page_id = gt_page_id) as title,
gt_country,gt_region from geo_tags,
(select avg(gt_lat) cen_gt_lat,avg(gt_lon) cen_gt_lon,count(*) from geo_tags
where gt_country='DE' and gt_region = 'MV') as zentrumdavon
where gt_country='DE' and gt_region = 'MV'
order by 1 desc limit 100;
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.