Tewiki: user-wise New pages count, using content translation

All publishings from Content translation tool, repeat publishings are not counted, first time overwriting is counted

SQL

use tewiki_p;
select
  actor_name as User,
  actor_name, count(actor_name) -- page_title-- , rev_len
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
--  and substr(rev_timestamp, 1, 4) in ("2021","2022","2023")
--  and actor_name = "Chaduvari"
group by actor_name
order by
  count(actor_name) desc

SQL

Checking query status...