SELECT

  log_timestamp AS `time`,

  actor_name AS `user`,

  log_namespace AS `namespace`,

  log_title AS `page`,

  comment_text AS `comment`

FROM

  logging_userindex

  LEFT JOIN `actor` ON log_actor = actor_id

  JOIN `comment` ON log_comment_id = comment_id

WHERE

  log_timestamp > 20200423100023

  AND log_type = 'delete'

  AND comment_text RLIKE "G10"

ORDER BY

  log_timestamp DESC

LIMIT

  0;