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

 FROM logging AS log

 LEFT JOIN actor ON log.log_actor = actor.actor_id

 JOIN comment ON log.log_comment_id = comment.comment_id

 WHERE log.log_timestamp > 20200223105944

 AND log.log_type = 'delete'

 AND comment.comment_text RLIKE "G10"

 ORDER BY log.log_timestamp DESC

 LIMIT 30;