Untitled query #91614

This query is marked as a draft This query has been published by ShellyYin.

SQL

SELECT 
    p.page_id, 
    p.page_title, 
    gt.gt_lat AS latitude, 
    gt.gt_lon AS longitude
FROM 
    enwiki_p.page AS p
JOIN 
    enwiki_p.geo_tags AS gt
ON 
    p.page_id = gt.gt_page_id
WHERE 
    p.page_namespace = 0  -- Only articles (excluding talk pages, categories, etc.)
    AND gt.gt_lat IS NOT NULL 
    AND gt.gt_lon IS NOT NULL;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...