#use dewiki_p; set @ns:=0;

use commonswiki_p;set @ns:=6;

set @iso1:='RS';

#set @iso2:='' or code

set @iso2:='06';

​

select sqrt((gt_lat - cen_gt_lat)*(gt_lat - cen_gt_lat) + (gt_lon - cen_gt_lon)*(gt_lon - cen_gt_lon)) as distanzungefaehr, 

       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,

       (select avg(gt_lat) cen_gt_lat,avg(gt_lon) cen_gt_lon,count(*) from geo_tags

        where 

            case 

                when @iso2=''

                then gt_country=@iso1

                else gt_country=@iso1 and gt_region=@iso2

                end) as zentrumdavon

        where

            case

                when @iso2=''

                then gt_country=@iso1 

                else gt_country=@iso1 and gt_region=@iso2

                end

       having ns= @ns

       order by 1 desc limit 500;

#and gt_region is null