Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Abhishek02bhardwaj
.
Toggle Highlighting
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_namespace = p2.page_namespace AND pagelinks.pl_title = p2.page_title WHERE p1.page_namespace = 0 -- Select only articles from the main namespace AND p2.page_namespace = 0; -- Also ensure links are to articles in the main namespace
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
.
Checking query status...