SELECT CONCAT('[[',

                (CASE log_namespace

                    WHEN 0 THEN ''

                    WHEN 2 THEN 'User:'

                    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, 118) -- source in :, User:, or Draft:

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

ORDER BY log_timestamp DESC

LIMIT 5;