SQL
AخA
USE fiwiki_p;
SELECT
gt_globe,
gt_primary,
gt_lat,
gt_lon,
gt_dim,
gt_country,
gt_region,
gt_name,
page_id,
page_namespace,
page_title,
page_len,
page_latest,
page_is_redirect,
pp_value as wikibase_item
FROM
geo_tags,
page,
page_props
WHERE
gt_page_id=page_id
AND pp_page=gt_page_id
AND pp_propname="wikibase_item"
AND gt_lat>59.656
AND gt_lat<70.093
AND gt_lon>19.270
AND gt_lon<31.587
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.