set @ns:=0;

#use commonswiki_p;set @ns:=6;

set @iso1:='GB';

#set @iso2:='' or code

set @iso2:='ABC';

​

select distinct gt_lat, gt_lon, 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 gt_lat*60\60 = get_lat and gt_lon*60\60 = get_lon

       having ns= @ns

       order title asc, gt_name asc limit 500;

​