use dewiki_p;

set @iso1:='AD';

set @iso2:='';

​

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,

       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  (if @iso2='' gt_country=@iso1 and gt_region is null else gt_country=@iso1 and gt_region=@iso2) as zentrumdavon

       where if @iso2='' gt_country=@iso1 and gt_region is null else gt_country=@iso1 and gt_region=@iso2

       order by 1 desc limit 50;

#        where gt_country=@iso1 and (if @iso2='' gt_region is null else gt_region=@iso2) as zentrumdavon

#       where gt_country=@iso1 and (if @iso2='' gt_region is null else gt_region=@iso2)

/*

        WHERE OrderNumber LIKE

  CASE WHEN IsNumeric(@OrderNumber) = 1 THEN 

    @OrderNumber 

  ELSE

    '%' + @OrderNumber

  END

        */