Telugu stats for July 2016

SQL

use tewiki_p;
#select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp < '20160801000000' and r.rev_timestamp > '20160630235959';
#select * from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp < '20160801000000' and r.rev_timestamp > '20160630235959';
#select sum(r.rev_len) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp < '20160801000000' and r.rev_timestamp > '20160630235959';
select user_name, user_editcount from user where user_registration < '20160801000000' and user_registration > '20160630235959' order by user_editcount;
SQL

Checking query status...
