Nepal iso codes

SQL

use dewiki_p;
select gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id) as title,gt_country,gt_region from geo_tags
where gt_country in ('NP');

select gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id) as title,gt_country,gt_region from geo_tags
where gt_country in ('NP') and isNull (gt_region);

/* development regions */
select gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id) as title,gt_country,gt_region from geo_tags
where gt_country in ('NP') and gt_region in ('1','2','3','4','5');

/* zone */
select gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id) as title,gt_country,gt_region from geo_tags
where gt_country in ('NP') and gt_region in ('BA','BH','DH','GA','JA','KA','KO','LU','MA','ME','NA','RA','SA','SE');
SQL

Checking query status...
