find objects by iso-codes

SQL

use dewiki_p;
set @iso1:='AT';
#set @iso2:='' or code
set @iso2:='';

/*
describe geo_tags;
select * from geo_tags where gt_region is null
limit 10;
*/
select gt_lat, gt_lon, gt_page_id, gt_name,
       (select page_namespace from page where page_id = gt_page_id) as ns,
       (select page_title from page where page_id = gt_page_id) as title,
       gt_country,gt_region from geo_tags
        where
        	case
            	when @iso2=''
                then gt_country=@iso1 and gt_region is null
                else gt_country=@iso1 and gt_region=@iso2
                end
       order by 1 desc limit 1000
       having ns = 0;

#and gt_region is null
SQL

Checking query status...
