use igwiki_p;

select

  substr(rev_timestamp, 1, 8) as Datee,

  count(substr(rev_timestamp, 1, 8)) as Translated_articles

from

  change_tag,

  change_tag_def,

  revision,

  page

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 ctd_name = "contenttranslation-v2"

  and rev_parent_id = 0

  and substr(rev_timestamp, 1, 4) = "2024"

  group by substr(rev_timestamp, 1, 8)

order by

  rev_timestamp