SELECT CONCAT(CASE src.page_namespace

                WHEN 0 THEN ''

                WHEN 2 THEN 'User:'

                WHEN 3 THEN 'User talk:'

                WHEN 4 THEN 'Wikipedia:'

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

              END, src.page_title) AS pagename, pr_level, pr_expiry, pr_cascade

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

JOIN page_restrictions ON pr_page = src.page_id

WHERE dbl.page_is_redirect = 1

  AND pr_type = 'edit';