SELECT CONCAT('[[',

                (CASE log_namespace

                    WHEN 0 THEN ''

                    WHEN 1 THEN 'Talk:'

                    WHEN 2 THEN 'User:'

                    WHEN 3 THEN 'User talk:'

                    WHEN 4 THEN 'Wikipedia:'

                    WHEN 5 THEN 'Wikipedia talk:'

                    WHEN 6 THEN ':File:'

                    WHEN 7 THEN 'File talk:'

                    WHEN 8 THEN 'MediaWiki:'

                    WHEN 9 THEN 'MediaWiki talk:'

                    WHEN 10 THEN 'Template:'

                    WHEN 11 THEN 'Template talk:'

                    WHEN 12 THEN 'Help:'

                    WHEN 13 THEN 'Help talk:'

                    WHEN 14 THEN ':Category:'

                    WHEN 15 THEN 'Category talk:'

                    WHEN 100 THEN 'Portal:'

                    WHEN 101 THEN 'Portal talk:'

                    WHEN 108 THEN 'Book:'

                    WHEN 109 THEN 'Book talk:'

                    WHEN 118 THEN 'Draft:'

                    WHEN 118 THEN 'Draft talk:'

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

                END),

                log_title,

                ']]') AS 'Moved from',

        CONCAT('[[Draft:', page_title, ']]') AS 'Currently at',

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

        log_comment,

        log_timestamp

FROM logging_logindex

JOIN page ON page_id=log_page

WHERE log_type = 'move'

    AND page_namespace = 118 -- Draft

ORDER BY log_timestamp DESC

LIMIT 1000;