This query is marked as a draft This query has been published by Teslaton.

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.

Checking query status...