Untitled query #86852

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

SQL

SELECT 
    p1.page_id AS article_id,
    p1.page_title AS article_title,
    p2.page_id AS linked_article_id,
    p2.page_title AS linked_article_title
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
AND 
    p1.page_id != p2.page_id; -- Exclude self-links

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...