use lawiki_p;

​

SELECT

    page_id,

    page_namespace,

    page_title,

    MAX(ct_rev_id),

    ct_params,

    user_name,

    rev_timestamp

FROM

    `change_tag`,

    `revision`,

    `user`,

    `page`

WHERE

    ctd_tag = 'contenttranslation' AND

    page_namespace = 0 AND

    rev_id = ct_rev_id AND

    rev_page = page_id AND

    rev_user = user_id

GROUP BY page_id, rev_timestamp

ORDER BY NULL;

​