IndicWIkis - New Articles & All New pages counts in a period

This query is marked as a draft This query has been published by Chaduvari.
SQL

use tewiki_p;
select "te",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "te",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";

use tawiki_p;
select "ta",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "ta",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";

use hiwiki_p;
select "hi",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "hi",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use bnwiki_p;
select "bn",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "bn",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use mlwiki_p;
select "ml",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "ml",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use knwiki_p;
select "kn",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "kn",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use mrwiki_p;
select "mr",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "mr",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use pawiki_p;
select "pa",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "pa",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";

use orwiki_p;
select "or",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "or",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use aswiki_p;
select "as",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "as",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use guwiki_p;
select "gu",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "gu",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
use urwiki_p;
select "ur",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000"
    and rev_parent_id=0;

select "ur",count(substr(rev_timestamp,1,4))
from
    revision,page,actor
where   page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and rev_timestamp >= "20230328000000"
	and rev_timestamp <= "20240327000000";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
