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, (select page_title from page where page_id = el_to) as title, el_id from externallinks where el_from=(select page_id from page where page_title = @page and page_namespace = 0) 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_title from page where page_id = gt_page_id) as title, gt_name from geo_tags
where (select page_id from page where page_title = @page and page_namespace = 0) = gt_page_id;
SQL

Checking query status...
