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
SQL
.
Toggle Highlighting
SQL
SELECT CONCAT( "* [[", CASE WHEN pl_from_namespace = 0 THEN "" WHEN pl_from_namespace = 1 THEN "Talk:" WHEN pl_from_namespace = 2 THEN "User:" WHEN pl_from_namespace = 3 THEN "User_talk:" WHEN pl_from_namespace = 4 THEN "Wikipedia:" WHEN pl_from_namespace = 5 THEN "Wikipedia_talk:" WHEN pl_from_namespace = 6 THEN "File:" WHEN pl_from_namespace = 7 THEN "File_talk:" WHEN pl_from_namespace = 8 THEN "MediaWiki:" WHEN pl_from_namespace = 9 THEN "MediaWiki_talk:" WHEN pl_from_namespace = 10 THEN "Template:" WHEN pl_from_namespace = 11 THEN "Template_talk:" WHEN pl_from_namespace = 12 THEN "Help:" WHEN pl_from_namespace = 13 THEN "Help_talk:" WHEN pl_from_namespace = 14 THEN "Category:" WHEN pl_from_namespace = 15 THEN "Category_talk:" WHEN pl_from_namespace = 100 THEN "Portal:" WHEN pl_from_namespace = 101 THEN "Portal_talk:" WHEN pl_from_namespace = 108 THEN "Book:" WHEN pl_from_namespace = 109 THEN "Book_talk:" WHEN pl_from_namespace = 118 THEN "Draft:" WHEN pl_from_namespace = 119 THEN "Draft_talk:" WHEN pl_from_namespace = 446 THEN "Education_Program:" WHEN pl_from_namespace = 447 THEN "Education_Program_talk:" WHEN pl_from_namespace = 710 THEN "TimedText:" WHEN pl_from_namespace = 711 THEN "TimedText_talk:" WHEN pl_from_namespace = 828 THEN "Module:" WHEN pl_from_namespace = 829 THEN "Module_talk:" WHEN pl_from_namespace = 2300 THEN "Gadget:" WHEN pl_from_namespace = 2301 THEN "Gadget_talk:" WHEN pl_from_namespace = 2302 THEN "Gadget_definition:" WHEN pl_from_namespace = 2303 THEN "Gadget_definition_talk:" END, page_title, "]]" ) Link, page_touched Timestamp FROM pagelinks JOIN page ON pl_from = page_id WHERE pl_title = 'SQL' AND pl_namespace = 2;
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...