use commonswiki_p;

​

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_type = "file" and 

    (

      (gt_lat between 49.176 and 49.215) and (gt_lon between 19.470 and 19.557) # VB

      # 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

  ;