Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Herzi Pinki
.
queries table geo-tags for non matching pairs of iso:3166-1 and iso:3166-2 codes. Does not check for false iso:3166-1 codes.
Toggle Highlighting
SQL
use dewiki_p; #describe geo_tags; #select gt_page_id,gt_lat,gt_lon,gt_name,gt_primary,(select page_title from page where page_id = gt_page_id) from geo_tags where gt_country='AT' and gt_region is null #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) from geo_tags, (select avg(gt_lat) cen_gt_lat,avg(gt_lon) cen_gt_lon,count(*) from geo_tags where gt_country='CH' and gt_region = 'TG') as zentrumdavon where gt_country='CH' and gt_region = 'TG' order by 1 desc limit 100; 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) from geo_tags, (select avg(gt_lat) cen_gt_lat,avg(gt_lon) cen_gt_lon,count(*) from geo_tags where gt_country='DE') as zentrumdavon where gt_country='DE' order by 1 desc limit 200;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...
