use tewiki_p;

select

--  concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) as Date_time,

--  actor_name as User,

  page_title-- , rev_len

  first_edit

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-v2"

  and rev_parent_id = 0

  and substr(rev_timestamp, 1, 6) in ("202209","202210")

  and actor_name = "Chaduvari"

order by

  first_edit desc