USE zhwiki_p;

SELECT logging2.log_timestamp, logging2.log_id, logging2.log_title, logging2.comment_text, (

  SELECT logging.log_id

  FROM logging

  WHERE logging2.log_title = logging.log_title

    AND logging.log_type = "create"

    AND logging.log_action = "create"

    AND logging.log_namespace = 0

    AND logging2.log_timestamp > logging.log_timestamp

  LIMIT 1

)

FROM (

SELECT log_timestamp, log_id, log_title, comment_text

FROM logging

LEFT JOIN comment ON log_comment_id = comment_id

WHERE log_type = "delete"

    AND log_action = "delete"

    AND log_namespace = 0

    AND comment_text LIKE "%G13%"

    AND log_timestamp > '201912010000' AND log_timestamp < '20200330235959'

ORDER BY log_timestamp DESC

) AS logging2

# LEFT JOIN comment ON logging.log_comment_id = comment_id