SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(rev_comment, ':',  2), ':', -1) AS 'Source wiki',

    CONCAT('[[',

           (CASE page_namespace

            WHEN 0 THEN ''

            WHEN 2 THEN 'User:'

            WHEN 4 THEN 'Wikipedia:'

            WHEN 10 THEN 'Template:'

            WHEN 14 THEN ':Category:'

            WHEN 118 THEN 'Draft:'

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

            END),

           page_title, ']]') AS 'Page',

           page_len,

           page_is_redirect

FROM revision

JOIN change_tag

    ON ct_rev_id = rev_id

JOIN page

    ON page_id = rev_page

WHERE ct_tag = 'contenttranslation'

    AND rev_timestamp >= 20160727115600;