Tewiki: Date wise NS0 new pages creation

SQL

USE tewiki_p;
select substr(rev_timestamp,1,8) as dated, count(substr(rev_timestamp,1,8))  as new_pages,  SUM(abs(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed)))) AS Gross_byte_count, 
    SUM(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed))) AS nett_byte_count
from page,revision rev,revision as parent
where page_id=rev_page
	and substr(rev_timestamp,1,6)="202001"
    and page_namespace=0
    and rev_parent_id=0
    and page_is_redirect=0
    and parent.rev_id=rev.parent_id
group by substr(rev_timestamp,1,8)

SQL

Checking query status...