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

SQL

AخA
 
select SUM(abs(CAST(rev2.rev_len as signed)-if(rev2.rev_parent_id=0,0,CAST(parent2.rev_len as signed)))) from revision rev2
            JOIN revision parent2 ON parent2.rev_id = rev2.rev_parent_id
            JOIN page p2 ON p2.page_id = rev2.rev_page
            join actor actor2 ON actor2.actor_id = rev2.rev_actor
        WHERE  
            p2.page_namespace = 0
            and rev2.rev_actor="Chaduvari"
            and rev2.rev_actor not in (select rev22.rev_actor from revision rev22 where rev22.rev_actor=rev2.rev_actor and rev22.rev_parent_id=0)
            group by rev2.rev_actor
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
All SQL code is licensed under CC0 License.

Checking query status...