use bnwiki_p;

​

-- When appropriate, change 'contenttranslation' to 'sectiontranslation'

set @cx_edit_tag = (

  select

    ctd_id

    edit_id

  from

    change_tag_def

  where

    ctd_name = 'contenttranslation'

);

​

select

    date_format(rev_timestamp, "%Y-%m-%d %H:%i:%s") as 'Time',

    actor_name as 'Username',

    replace(page_title, '_', ' ') as 'Page title'

from

    revision,

    page,

    change_tag,

    actor

where

    -- if needed, add a condition for rev_timestamp

    page_id = rev_page and

    ct_rev_id = rev_id and

    ct_tag_id = @cx_edit_tag and

    rev_actor = actor_id 

order by

    rev_timestamp desc

limit

    50; -- Can be adjusted