Untitled query #3437

SQL

use kgwiki_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(page_touched), MONTH(page_touched) from page where page_namespace = 0 and page_is_redirect =0 group by YEAR(page_touched), MONTH(page_touched);
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...
