find coords rounded to minutes per iso code

SQL

set @ns:=0;
#use commonswiki_p;set @ns:=6;
set @iso1:='CL';
#set @iso2:='' or code
set @iso2:='';

select distinct gt_lat, gt_lon,
	   #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(gt_lat*3600,4) mod 60 = 0 and round(gt_lon*3600,4) mod 60 = 0
        and not gt_type in ('state', 'adm1st', 'adm2nd', 'country')
       having ns= @ns
       order by title asc, gt_name asc limit 500;
SQL

Checking query status...
