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

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.

Checking query status...