USE eswiki_p;

DESCRIBE geo_tags;

/*

SELECT CONCAT('[[', page_title, ']]') AS Sida, gt_name, gt_type, gt_lat, gt_lon FROM geo_tags

INNER JOIN page ON gt_page_id = page_id

WHERE gt_country = 'AX' AND gt_type = 'mountain' 

ORDER BY page_title

LIMIT 1000;

​

SELECT page_title, gt_type, gt_name, gt_lat, gt_lon, gt_country, gt_region 

FROM geo_tags

LEFT OUTER JOIN page ON page_id = gt_page_id

WHERE gt_country = 'VE'

ORDER BY page_title

LIMIT 25*/

SELECT *

FROM geo_tags

WHERE gt_country = 'VE'

​