Tewiki:Yearly bytes added

SQL

USE tewiki_p;
SELECT substr(rev.rev_timestamp,1,4) dated, count(substr(rev.rev_timestamp,1,4)),
    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
GROUP BY substr(rev.rev_timestamp,1,4)
order by rev.rev_timestamp
SQL

Checking query status...
