Replicas browser and optimizer
checking types of coordinates
This query is marked as a draft
This query has been published
use dewiki_p; #describe geo_tags; /* seems that gt_type is null only for images */ select gt_type, count(*) as c from geo_tags group by gt_type order by c desc; select gt_type, gt_dim, 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 where gt_type in ( 'landscape') order by gt_dim desc limit 200;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in