max distance from center - general

SQL

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

#gt_country	binary(2)
#gt_region	varbinary(3)
#describe iso;
#insert into iso (c)
#select distinct gt_country as c from geo_tags

#drop iso

CREATE PROCEDURE farAwayObjects()
BEGIN

declare iso cursor for
	select distinct gt_country from geo_tags;
END;

Call farAwayObjects;
/*
BEGIN

    create table #ids
    (
        rn int,
        id int
    )

    insert into #ids (rn, id)
    select distinct row_number() over(order by id) as rn, id
    from table

    declare @id int
    declare @totalrows int = (select count(*) from #ids)
    declare @currentrow int = 0

    while @currentrow <  @totalrows  
    begin 
        set @id = (select id from #ids where rn = @currentrow)

        exec stored_proc @varName=@id, @otherVarName='test'

        set @currentrow = @currentrow +1
    end  

END

DECLARE iso CURSOR FOR SELECT gt_country from geo_tags
#DECLARE iso CURSOR FOR SELECT distinct gt_country, gt_region from geo_tags order by 1,2;
declare  iso CURSOR local FOR
	SELECT distinct gt_country, gt_region from geo_tags order by 1,2;
OPEN @iso;
FETCH NEXT;
FROM @iso INTO @iso1, @iso2;
WHILE @@FETCH_STATUS = 0
BEGIN
#
    FETCH NEXT
    FROM @iso INTO @iso1, @iso2
END

CLOSE @iso;
DEALLOCATE @iso;

/*
select distinct gt_country, gt_region from geo_tags order by 1,2 asc limit 10;

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_title from page where page_id = gt_page_id) as title,
       (select distinct gt_country from geo_tags order by 1) as iso1,
       #(select distinct gt_region from geo_tags where gt_country=iso1 order by 1) as iso2,
       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 and gt_region is null
        		else gt_country=@iso1 and gt_region=@iso2
        		end) as zentrumdavon
        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 50;
       
*/
SQL

Checking query status...
