Tewiki testing

SQL

USE tewiki_p;
set @allNewPages = (select count(substr(rev_timestamp,1,8))  as All_NS_new_pages)
from page,revision
where page_id=rev_page
	and substr(rev_timestamp,1,6)="202101"
    and rev_parent_id=0
    and page_is_redirect=0
group by substr(rev_timestamp,1,8);
set @NS0NewPages = select count(substr(rev_timestamp,1,8))  as mainspace_new_pages
from page,revision
where page_id=rev_page
	and substr(rev_timestamp,1,6)="202101"
    and page_namespace=0
    and rev_parent_id=0
    and page_is_redirect=0
group by substr(rev_timestamp,1,8);
show @allNewPages,@NS0NewPages
SQL

Checking query status...
