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 119 THEN 'Draft talk:'

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

               END),

              log_title, ']]'),

       log_timestamp, log_user_text, log_comment

FROM logging_logindex

WHERE log_action='delete'

      AND log_type='delete'

      AND log_title REGEXP 'novo.*tech' COLLATE utf8_general_ci;