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

SQL

AخA
 
select SUM(abs(CAST(rev1.rev_len as signed)-if(rev1.rev_parent_id=0,0,CAST(parent1.rev_len as signed)))) from revision rev1
    left JOIN revision parent1
    ON parent1.rev_id = rev1.rev_parent_id
    left JOIN page p1
    ON p1.page_id = rev1.rev_page
    WHERE  
     p1.page_namespace = 0
    and p1.page_title= "మహాత్మా_గాంధీ"
    group by rev1.rev_page
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...