Kannada stats for July 2016

SQL

use knwiki_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';
desc user;
select * from user where 1 order by user_id desc limit 1;
SQL

Checking query status...
