Translation stats in a wiki - Articles and sections

SQL

set @dbname = 'bnwiki';

set @ct_tag_id = (
  select
    ctd_id
  from
    change_tag_def
  where
    ctd_name = 'contenttranslation'
);

set @sx_tag_id = (
  select
    ctd_id
  from
    change_tag_def
  where
    ctd_name = 'sectiontranslation'
);


set @created_cx = (
  select
    count(rev_id)
  from
    change_tag,
    page,
    revision
  where
    page_id = rev_page and
    page_namespace = 0 and
    rev_id = ct_rev_id and
    rev_timestamp like '2021%' and
    rev_parent_id = 0 and
    ct_tag_id = @ct_tag_id
);
 
set @created_sx = (
  select
    count(rev_id)
  from
    change_tag,
    page,
    revision
  where
    page_id = rev_page and
    page_namespace = 0 and
    rev_id = ct_rev_id and
    rev_timestamp like '202105%' and
    ct_tag_id = @sx_tag_id
);
  
select
  @dbname,
  @created_cx 'New CX articles',
  @created_sx 'New SX sections';
SQL

Checking query status...
