Tewiki:Yearly bytes added

SQL

USE tewiki_p;
SELECT substr(rev.rev_timestamp,1,4) dated,
    SUM(abs(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed)))) AS Gross_bytes_added, 
    SUM(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed))) AS nett_bytes_added
FROM revision rev
left JOIN revision parent
ON parent.rev_id = rev.rev_parent_id
left JOIN page
ON page_id = rev.rev_page
 WHERE page_namespace != 0
and page_is_redirect=0
and page_id not in (select pp_page from page_props where pp_propname="disambiguation")
GROUP BY substr(rev.rev_timestamp,1,4)
order by substr(rev.rev_timestamp,1,4)
SQL

Checking query status...
