SELECT rc_title, rc_cur_id, rc_user_text, max_abc10_ts, COALESCE(article_creator, r2.rev_user_text) as article_creator FROM (

  SELECT rc_title, rc_user_text, rc_cur_id, article_creator, max(t.abc10_ts) as max_abc10_ts, min(r1.rev_timestamp) as min_rev_ts FROM (

SELECT 

    rc1.rc_timestamp, rc1.rc_user_text as rc_user_text, rc1.rc_cur_id, rc1.rc_title, rc1.rc_this_oldid, t.rev_timestamp as abc10_ts, r1.rev_timestamp, l.log_user_text as article_creator

FROM 

   recentchanges_compat AS rc1

   LEFT JOIN revision_compat as r1

    ON rc1.rc_cur_id=r1.rev_page 

    AND rc1.rc_this_oldid>r1.rev_id

    AND r1.rev_timestamp>20200000000000

    AND r1.rev_user_text="Abc10" 

    LEFT JOIN logging_compat as l

    ON log_page=rc_cur_id

    AND log_namespace=0

    AND log_type="create"

    AND log_action="create"

    AND log_user_text="Abc10"

    AND log_id>10573200

WHERE 

rc1.rc_type="mw.edit"

AND rc1.rc_namespace=0

AND rc1.rc_user_text IN (

  "103.14.26.24", 

  "108.163.158.33", 

  "108.163.158.46", 

  "159.8.124.166", 

  "169.59.72.217", 

  "176.9.201.11", 

  "178.211.131.72"

) 

GROUP BY rc1.rc_id

) as t LEFT JOIN revision as r1 ON rev_page=rc_cur_id

  GROUP BY rc_cur_id) as tt LEFT JOIN revision_compat as r2 ON r2.rev_page=tt.rc_cur_id AND r2.rev_timestamp=tt.min_rev_ts