use bnwiki_p;

​

set @cx_edit_tag = (

  select

    ctd_id

  from

    change_tag_def

  where

    ctd_name = 'contenttranslation'

);

​

select

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

    actor_name as 'Username',

    page_title as 'Page title'

from

    revision,

    page,

    change_tag,

    actor

where

    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;