SELECT log.log_timestamp AS `time`, user_name AS `user`, log.log_namespace AS `Namespace`, log.log_title AS `page`, comment.comment_text AS `comment`

 FROM logging AS log

 LEFT JOIN user ON log.log_user = user_id

 JOIN comment ON log.log_comment_id = comment.comment_id

 WHERE log.log_type = 'delete'

 AND comment.comment_text RLIKE "WP:CSD"

 AND comment.comment_text RLIKE "U2"

 AND log.log_namespace = 3

 ORDER BY log.log_timestamp DESC

 LIMIT 200;