Tewiki:Yearly bytes added

SQL

USE tewiki_p;
SELECT concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2)) dated, count(concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2))),
    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 substr(rev.rev_timestamp,1,4)
SQL

Checking query status...
