Untitled query #25301

SQL

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,
       rev_timestamp Timestamp
FROM   pagelinks 
       JOIN page 
         ON pl_from = page_id
       JOIN revision
         ON page_latest = rev_id 
WHERE  pl_title = 'SQL' 
       AND ( pl_namespace = 2 OR pl_namespace = 3) 
ORDER BY rev_timestamp DESC;
SQL

Checking query status...
