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,
    r2.rev_user_text
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 r1.rev_id>17811428
WHERE 
    p.page_namespace=0
    AND p.page_id = r1.rev_page
	AND r1.rev_id>18630374
    AND r1.rev_id < 18630374
    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...