SELECT CONCAT(CASE src.page_namespace

                WHEN 2 THEN 'User:'

                WHEN 3 THEN 'User talk:'

                WHEN 5 THEN 'Wikipedia talk:'

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

              END, src.page_title) AS pagename

FROM page AS src

JOIN redirect ON rd_from = src.page_id

JOIN page AS dbl ON dbl.page_namespace = rd_namespace AND dbl.page_title = rd_title

WHERE dbl.page_is_redirect = 1

  AND (src.page_title LIKE '%.js' OR src.page_title LIKE '%.css');