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

SQL

AخA
 
SELECT
    actor_name,
    SUM(abs(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed)))) as Total_Gross_bytes,
        (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
           JOIN revision parent1 ON parent1.rev_id = rev1.rev_parent_id
           JOIN page p1 ON p1.page_id = rev1.rev_page
           join actor actor1 ON actor1.actor_id = rev1.rev_actor 
        WHERE  
            p1.page_namespace = p.page_namespace
            and rev1.rev_actor=rev.rev_actor
            and rev1.rev_actor in (select rev11.rev_actor from revision rev11 where rev11.rev_actor=rev1.rev_actor and rev11.rev_parent_id=0)
            group by rev1.rev_actor) AS Bytes_on_self_created_page
         
/*         (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 = p.page_namespace
            and rev2.rev_actor=rev.rev_actor
            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) AS Bytes_on_other_pages
*/
FROM revision rev
left join actor ON actor_id = rev.rev_actor
left JOIN revision parent ON parent.rev_id = rev.rev_parent_id
left JOIN page p ON p.page_id = rev.rev_page
WHERE  
 p.page_namespace = 0
 and actor_name="Chaduvari"
GROUP BY rev.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...