Untitled query #77588

SQL

SET @page=(SELECT page_id FROM page
           WHERE page_namespace = 0 -- main namespace
             AND page_title = 'Pagrindinis_puslapis');

SELECT CONCAT('[[',
              CASE pl_namespace
                WHEN -2 THEN 'Media:'               WHEN -1 THEN 'Special:'
                WHEN 0 THEN ''                      WHEN 1 THEN 'Talk:'
                WHEN 2 THEN 'User:'                 WHEN 3 THEN 'User talk:'
                WHEN 4 THEN 'Wikipedia:'            WHEN 5 THEN 'Wikipedia talk:'
                WHEN 6 THEN ':File:'                WHEN 7 THEN 'File talk:'
                WHEN 8 THEN 'MediaWiki:'            WHEN 9 THEN 'MediaWiki talk:'
                WHEN 10 THEN 'Template:'            WHEN 11 THEN 'Template talk:'
                WHEN 12 THEN 'Help:'                WHEN 13 THEN 'Help talk:'
                WHEN 14 THEN ':Category:'           WHEN 15 THEN 'Category talk:'
                WHEN 100 THEN 'Portal:'             WHEN 101 THEN 'Portal talk:'
                WHEN 102 THEN 'Vikiprojektas:'      WHEN 103 THEN 'Vikiprojekto aptarimas:'
                ELSE CONCAT('{{ns:', pl_namespace, '}}:')
              END,
              pl_title,
              ']]') AS link,
       pl_namespace AS namespace
FROM pagelinks
WHERE pl_from = @page
SQL

Checking query status...
