find coords rounded to minutes per iso code

SQL

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;

SQL

Checking query status...