SELECT CONCAT('[[',

              CASE page_namespace

                WHEN 0 THEN ''

                WHEN 2 THEN 'User:'

                WHEN 3 THEN 'User talk:'

                WHEN 4 THEN 'Wikipedia:'

                WHEN 5 THEN 'Wikipedia talk:'

                WHEN 9 THEN 'MediaWiki talk:'

                WHEN 11 THEN 'Template talk:'

                WHEN 12 THEN 'Help:'

                ELSE CONCAT('{{ns:', page_namespace, '}}:')

              END,

              page_title, ']]') AS 'pagename',

       iwl_title

FROM iwlinks

  JOIN page ON page_id = iwl_from

WHERE iwl_prefix = 'quarry'

ORDER BY page_namespace ASC, page_title ASC;