use scwiki_p;

​

SELECT

    rev_actor,

    actor_name,

    count(revision.rev_id) as articles_created

FROM

    change_tag,

    actor,

    revision

WHERE

    revision.rev_parent_id = 0 AND

    ct_tag_id = (select ctd_id from change_tag_def where ctd_name = 'contenttranslation') AND

    rev_id = ct_rev_id AND

    rev_actor = actor_id

GROUP BY

    rev_actor

ORDER BY

    articles_created DESC

LIMIT

    100;