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

set @cx_edit_tag = (

    select

        ctd_id

    from

        change_tag_def

    where

        ctd_name = 'contenttranslation'

);

​

SELECT

    rev_timestamp,

    actor_name,

    page_title,

    page_namespace,

    page_id,

    MAX(ct_rev_id)

FROM

    `change_tag`,

    `revision`,

    `actor`,

    `page`

WHERE

    rev_timestamp like '2025%' AND

    ct_tag_id = @cx_edit_tag AND

    page_namespace = 0 AND

    rev_id = ct_rev_id AND

    rev_page = page_id AND

    rev_actor = actor_id

GROUP BY

    page_id,

    rev_timestamp

ORDER BY

    rev_timestamp;

​