Fiwiki edit analysis 2

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

SQL

SELECT 
	p.page_title,
    r1.rev_timestamp,
    r1.rev_user_text as ip,
    r2.rev_user_text as user
FROM 
    page as p,
	revision_compat AS r1
    LEFT JOIN revision_compat as r2 
    	ON r1.rev_page=r2.rev_page 
        AND r2.rev_user_text="Abc10" 
        AND r2.rev_id<r1.rev_id 
        AND r2.rev_id>17811428
WHERE 
    p.page_namespace=0
    AND p.page_id = r1.rev_page
	AND r1.rev_id>18630374
    AND r1.rev_id < 19457868
    AND r1.rev_user=0
    AND r1.rev_user_text LIKE "95.175%"

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...