use knwiki_p;

#SELECT count(distinct(page_id)) FROM pagelinks INNER JOIN page ON pl_from = page_id WHERE page_namespace = 0 AND page_is_redirect = 0;

#select count(page_id) from page where page_namespace=0 and page_is_redirect=0;

select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and rev_timestamp > '20150600000000' and rev_timestamp < '20150800000000';

​