Fiwiki edit analysis

SQL

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.rev_timestamp) as max_rev_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, max(t.rev_timestamp) as max_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
SQL

Checking query status...
