SQL
x
use commonswiki_p;
set @cat1 := "All_media_needing_categories_as_of_20%";
set @cat2 := "Media_needing_category_review_as_of_%";
#describe geo_tags;
select distinct
(select page_title from page where page_id = gt_page_id) as title
,gt_page_id, gt_lat, gt_lon
# ,gt_country, gt_region
from
geo_tags, categorylinks
where
gt_page_id = cl_from and
(cl_to like @cat1 or cl_to like @cat2) and cl_type = "file" and
(
(gt_lat > 47.729 and gt_lat < 49.614 and gt_lon > 16.832 and gt_lon < 22.566) # SK outer rect
and not (gt_lat > 49.036 and gt_lon < 18.050) # NW: CZ Morava
and not (gt_lat > 49.463 and gt_lon > 19.580) # NE: PL
and not (gt_lat > 49.239 and gt_lon > 19.826 and gt_lon < 20.095) # NE: PL Zakopane
and not (gt_lat < 48.645 and gt_lon > 22.253) # SE: UA Uzhorod
and not (gt_lat < 48.332 and gt_lon > 20.381) # SE: HU 1
and not (gt_lat < 48.037 and gt_lon > 18.861) # SE: HU 2
and not (gt_lat < 47.987 and gt_lon < 17.325) # SW: AT, HU
)
# order by 1
order by title
# 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.