Untitled query #41521

SQL

use mrwikisource_p;
select count(*) as June19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20190700000000 and rev_timestamp > 20190600000000;
select count(*) as July19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20190800000000 and rev_timestamp > 20190700000000;
select count(*) as Aug19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20190900000000 and rev_timestamp > 20190800000000;
select count(*) as Sep19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20191000000000 and rev_timestamp > 20190900000000;
select count(*) as Oct19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20191100000000 and rev_timestamp > 20191000000000;
select count(*) as Nov19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20191200000000 and rev_timestamp > 20191100000000;
select count(*) as Dec19 from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = 104 and rev_timestamp <= 20200100000000 and rev_timestamp > 20191200000000;
SQL

Checking query status...
