SELECT CONCAT('[[',

                (CASE log_namespace

                    WHEN 0 THEN ''

                    WHEN 2 THEN 'User:'

                    WHEN 3 THEN 'User talk:'

                    WHEN 118 THEN 'Draft:'

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

                END),

                log_title,

                ']]') AS 'Moved from',

        log_params,

        CONCAT('[[User:', log_user_text, '|]]') AS 'Moved by',

        log_comment,

        log_timestamp

FROM logging_logindex

WHERE log_type = 'move'

    AND log_namespace IN (0,2,3,118)

    AND log_params RLIKE 'target";s:[0-9]+:"Wikipedia talk:'

    AND log_params NOT RLIKE 'target";s:[0-9]+:"Wikipedia talk:Articles for creation/'

ORDER BY log_timestamp DESC;