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

  SELECT comment_text AS `comment`

  FROM comment

  WHERE log.log_comment_id = comment.comment_id

)

 FROM logging AS log

 JOIN actor ON log.log_actor = actor.actor_id

 WHERE log.log_timestamp > 20191102162617

 AND log.log_type = 'delete'

 AND comment.comment_text RLIKE "G10"

 ORDER BY log.log_timestamp DESC

 LIMIT 2;