geo_tags queries, skwiki

SQL

USE skwiki_p;

select @lat := 49.198333, @lon := 19.51666, @radius := 10000;
select page_title, geo_tags.* from geo_tags, page where page_id = gt_page_id and gt_lat between(@lat - @radius/111000, @lat + radius/111000) and gt_lon between(@lon - @radius/111000, @lon + radius/111000) order by gt_lat limit @limit;
select page_title, geo_tags.* from geo_tags, page where page_id = gt_page_id and page_title in ('Veľké_Borové', 'Srňacie', 'Annina_dolina', 'Prosečné_(vrch)', 'Svorad_(plošina)');
select count(*) from geo_tags;
select gt_primary, count(*) as count from geo_tags group by gt_primary order by count desc;
select gt_type, count(*) as count from geo_tags group by gt_type order by count desc;
select gt_country, count(*) as count from geo_tags group by gt_country order by count desc;
SQL

Checking query status...
