Untitled query #69243

This query is marked as a draft This query has been published by Zache.

SQL

SELECT 
   r1.rev_id, rc1.rc_timestamp, rc1.rc_title, rc1.rc_this_oldid
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.rc_user_text="Abc10" 
WHERE 
rc1.rc_type="mw.edit"
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") 
;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...