Translations on each version

SQL

USE eswiki_p;

set @contenttranslation_tag_id = ( select ctd_id from change_tag_def where ctd_name = 'contenttranslation' );
set @contenttranslation_needcheck_tag_id = ( select ctd_id from change_tag_def where ctd_name = 'contenttranslation-needcheck' );
set @contenttranslation_v2_tag_id = ( select ctd_id from change_tag_def where ctd_name = 'contenttranslation-v2' );

select
  ct_tag_id,
  ctd_name,
  ctd_count 
from
  change_tag
  join change_tag_def on ct_tag_id=ctd_id
where
  ct_tag_id in (
    @contenttranslation_tag_id,
    @contenttranslation_needcheck_tag_id,
    @contenttranslation_v2_tag_id
  )
group by
  ct_tag_id;
SQL

Checking query status...
