Untitled query #69243

SQL

SELECT 
   rc1.rc_timestamp, rc1.rc_title, rc1.rc_this_oldid, 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_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
;
SQL

Checking query status...
