Untitled query #72188

SQL

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

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,
       p1.page_id = 5177228,
       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;
SQL

Checking query status...
