Untitled query #25680

SQL

use dewiki_p;
set @pageid:=5404045;
set @page:="Admiral_Nachimow_(1885)";

#describe geo_tags;
select gt_lat, gt_lon, gt_page_id, (select page_title from page where page_id = gt_page_id) as title, gt_name from geo_tags
where @pageid = gt_page_id;

#select pl_from, pl_title from pagelinks where pl_from=@pageid;
select el_from, el_to , el_id from externallinks where el_from=@pageid and el_to like "%/tools.wmflabs.org/geohack/geohack.php%";

select page_id, page_title from page where page_title like @page and page_namespace = 0;
select gt_lat, gt_lon, gt_page_id, (select page_id from page where page_title = @page and page_namespace = 0) as id, gt_name from geo_tags
where id = gt_page_id;
SQL

Checking query status...
