Fork of Indic Wikis: Year-wise count of content translation new articles by Chaduvari
This query is marked as a draft This query has been published by UOzurumba (WMF).

SQL

​x
 
use tewiki_p;
select substr(rev_timestamp,1,4) as yeard,count(substr(rev_timestamp,1,4)) tewiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use tawiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) tawiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use hiwiki_p;
select substr(rev_timestamp,1,4) as hi,count(substr(rev_timestamp,1,4)) hiwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use mlwiki_p;
select substr(rev_timestamp,1,4) as ml,count(substr(rev_timestamp,1,4)) mlwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use knwiki_p;
select substr(rev_timestamp,1,4) as kn,count(substr(rev_timestamp,1,4)) knwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use bnwiki_p;
select substr(rev_timestamp,1,4) as bn,count(substr(rev_timestamp,1,4)) bnwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use mrwiki_p;
select substr(rev_timestamp,1,4) as mr,count(substr(rev_timestamp,1,4)) mrwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use pawiki_p;
select substr(rev_timestamp,1,4) as pa,count(substr(rev_timestamp,1,4)) pawiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use guwiki_p;
select substr(rev_timestamp,1,4) as gu,count(substr(rev_timestamp,1,4)) guwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use urwiki_p;
select substr(rev_timestamp,1,4) as ur,count(substr(rev_timestamp,1,4)) urwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use orwiki_p;
select substr(rev_timestamp,1,4) as orr,count(substr(rev_timestamp,1,4)) orwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use aswiki_p;
select substr(rev_timestamp,1,4) as ass,count(substr(rev_timestamp,1,4)) aswiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
​
use satwiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) satwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
​
use kswiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) kswiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
    
use tlwiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) tlwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
use bclwiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) bclwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
use astwiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) astwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
 use wuuwiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) wuuwiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
  use zh_yuewiki_p;
select substr(rev_timestamp,1,4) as ta,count(substr(rev_timestamp,1,4)) zh_yuewiki_count
from
    change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
    and rev_id=ct_rev_id
    and page_id=rev_page
    and page_namespace=0
    and page_is_redirect=0
    and actor_id=rev_actor
    and ctd_name = "contenttranslation" 
    and rev_parent_id=0
group by substr(rev_timestamp,1,4)
    order by substr(rev_timestamp,1,4);
    
​
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
All SQL code is licensed under CC0 License.

Checking query status...