SELECT

    CONCAT('[[',

        -- there has got to be a better way to do this

        (CASE page_namespace

            WHEN 0 THEN ''

            WHEN 2 THEN 'User'

            WHEN 3 THEN 'User talk'

            WHEN 4 THEN 'Wikipedia'

            WHEN 12 THEN 'Help'

            ELSE CONCAT('ns', page_namespace)

        END),

        ':',

        page_title,

        ']]') AS 'from',

    CONCAT('[[fr:', rd_title, ']]') AS 'to'

FROM redirect

JOIN page ON rd_from = page_id

WHERE rd_title 'fr:'