Percent of languages created using Content Translation - T215813

SQL

use cawiki_p;

set @month = '201602';

set @wiki = 'cawiki';

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

set @created_total = (
  select
    count(rev_id) 
  from
    page,
    revision
  where
    page_id = rev_page and
    page_namespace = 0 and
    rev_timestamp like concat(@month, '%') and
    rev_parent_id = 0
);

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 concat(@month, '%') and
    rev_parent_id = 0 and
    ct_tag_id = @ct_tag_id
);

set @created_non_cx = (
  select (@created_total - @created_cx)
);

select
  @month as "month",
  @wiki as "wiki",
  @created_cx as "created with CX",
  @created_non_cx as "created not with CX",
  concat('%', (@created_cx / ( @created_cx + @created_non_cx ) * 100)) as "% created with CX";
SQL

Checking query status...
