Tewiki: Date-wise bytes added

SQL

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

Checking query status...
