use elwiki_p;

select t.ct_rev_id, t.ct_params, r.rev_user_text, p.page_title#r.rev_page, 

from change_tag t

INNER JOIN revision r on r.rev_id=t.ct_rev_id

INNER JOIN page p on r.rev_page=p.page_id

where t.ct_tag="contenttranslation";

​

use elwiki_p;

select r.rev_user_text, count(r.rev_user)

from change_tag t

INNER JOIN revision r on r.rev_id=t.ct_rev_id

where t.ct_tag="contenttranslation"

group by r.rev_user_text

order by count(r.rev_user) desc

limit 20;