Regex search of deletion logs

SQL

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;
SQL

Checking query status...
