Untitled query #86868

SQL

SELECT 
    p1.page_id AS article_id,
    p1.page_title AS article_title,
    CONCAT('https://en.wikipedia.org/wiki/', REPLACE(p1.page_title, ' ', '_')) AS article_url,
    p2.page_id AS linked_article_id,
    p2.page_title AS linked_article_title,
    CONCAT('https://en.wikipedia.org/wiki/', REPLACE(p2.page_title, ' ', '_')) AS linked_article_url
FROM 
    pagelinks
JOIN 
    page AS p1 
    ON pagelinks.pl_from = p1.page_id
JOIN 
    page AS p2
    ON pagelinks.pl_target_id = p2.page_id
WHERE 
    p1.page_namespace = 0  -- Only select articles from the main namespace

LIMIT 1000000;
SQL

Checking query status...
