SQL
x
SELECT distinct 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 OR pl_namespace = 3)
ORDER BY page_touched DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.