Untitled query #3441

SQL

use fiwiki_p;
/*
select count(*) from revision join page on revision.rev_page=page.page_id where page_namespace=0;
select count(*) from revision join page on revision.rev_page=page.page_id where page_namespace!=0;
*/

/*
select count(*) from page where page_namespace != 0;
select count(*) from page where page_namespace = 0 and page_is_redirect =0;
select count(*) from page where page_namespace = 0 and page_is_redirect =1;
select page_namespace,count(*) from page group by page_namespace;
select * from page where page_namespace=0 limit 100;
*/

select count(*), YEAR(revision.rev_timestamp), MONTH(revision.rev_timestamp) from page  join revision on page.page_latest=revision.rev_id where page_namespace = 0 and page_is_redirect =0 and lower(rev_user_text) not like '%bot%' group by YEAR(revision.rev_timestamp), MONTH(revision.rev_timestamp) ;

/*
select page_title, YEAR(page_touched), MONTH(page_touched) from page where page_namespace = 0 and page_is_redirect =0;
*/

/*
select count(1), YEAR(t),MONTH(t) from(SELECT count(*) e_c, max(rev_timestamp) t from revision_userindex where lower(rev_user_text) not like '%bot%' group by rev_page ) as created group by YEAR(t),MONTH(t);
select count(1), YEAR(t),MONTH(t) from(SELECT count(*) e_c, min(rev_timestamp) t from revision_userindex where lower(rev_user_text) not like '%bot%' group by rev_page ) as created group by YEAR(t),MONTH(t);
*/
SQL

Checking query status...
