SELECT

  log_timestamp AS `time`,

  actor_name AS `user`,

  log_namespace AS `namespace`,

  log_title AS `page`,

  comment_logging AS `comment`

FROM

  logging_userindex

  LEFT JOIN `actor` ON log_actor = actor_id

  JOIN `comment` ON log_comment = comment_id

WHERE

  log_timestamp > 20200419064838

  AND log_type = 'delete'

  AND comment_text RLIKE "G10"

ORDER BY

  log_timestamp DESC

LIMIT

  10;