Untitled query #12373

SQL

use commonswiki_p;
#select gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id and page_namespace = '6'),gt_country,gt_region from geo_tags
#where round (gt_lat,0)=48 and round(gt_lon, 0)=16 limit 100;
#describe geo_tags;
#describe page;
#select distinct gt_lat, gt_lon count from geo_tags;
#select count(distinct gt_lat, gt_lon) from geo_tags, page where page_id = gt_page_id and page_namespace != '6';
use dewiki_p;
select (select page_title from page where page_id = gt_page_id) as title from geo_tags where 
gt_country='AL' and gt_region not in ('01','02','03','04','05','06','07','08','09','10','11','12'/*,'BR','BU','DI','DL','DR','DV','EL','ER','FR','GJ','GR','HA','KA','KB','KC','KO','KR','KU','LB','LE','LU','MK','MM','MR','MT','PG','PQ','PR','PU','SH','SK','SR','TE','TP','TR','VL'*/)
;
SQL

Checking query status...
