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 from page where page_title like @page;
#select gt_lat, gt_lon, gt_page_id, (select page_id from page where page_title = @page) as id, gt_name from geo_tags
#where id = gt_page_id;
SQL

Checking query status...
