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 10 THEN 'Template:'

                      WHEN 11 THEN 'Template talk:'

                      WHEN 14 THEN ':Category:'

                      WHEN 15 THEN 'Category talk:'

                      WHEN 100 THEN 'Portal:'

                      WHEN 118 THEN 'Draft:'

                      WHEN 119 THEN 'Draft talk:'

                      WHEN 828 THEN 'Module:'

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

                    END, log_title, ']]') AS 'page',

       DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS 'timestamp',

       comment_text

FROM logging_userindex

  JOIN actor_logging ON log_actor=actor_id

  JOIN comment_logging ON comment_id=log_comment_id

WHERE log_type = 'delete'

  AND log_action = 'delete'

  AND actor_name = 'RHaworth'

  AND comment_text NOT LIKE '%[[WP:CSD%'

  AND comment_text NOT LIKE '%[[Wikipedia:CSD%'

  AND comment_text NOT RLIKE '.*\[\[[AFRGT][1-9][0-9]?(\]\]|\|).*'

ORDER BY log_timestamp DESC

LIMIT 1000;