set @ns:=0;

#use commonswiki_p;set @ns:=6;

set @iso1:='AT';

#set @iso2:='' or code

set @iso2:='4';

​

select distinct gt_lat, gt_lon, gt_dim,

       #round(gt_lat*3600,3) mod 60 as gt_lat_sec, round(gt_lon*3600,3) mod 60 as gt_lon_sec,

       gt_type, gt_page_id, gt_name,

       p1.page_namespace as ns,

       p1.page_title as title,

       gt_country,gt_region FROM geo_tags AS g1 JOIN page AS p1 ON g1.gt_page_id = p1.page_id

        where

            case

                when @iso2=''

                then gt_country=@iso1 and gt_region is null

                else gt_country=@iso1 and gt_region=@iso2

                end

        and round(abs(gt_lat)*3600,4) mod 60 = 0 and round(abs(gt_lon)*3600,4) mod 60 = 0

        and not gt_type in ('state', 'adm1st', 'adm2nd', 'country')

        and gt_dim <= 10000

       having ns= @ns

       order by title asc, gt_name asc limit 500;

​