Untitled query #74247

SQL

SELECT 
    COUNT(*) AS users_with_languages,
    SUM(num_edits) AS total_num_edits
FROM (
    SELECT r.rev_actor AS user_id, COUNT(DISTINCT r.rev_id) AS num_edits, COUNT(DISTINCT b.babel_lang) AS num_languages
    FROM revision r
    JOIN change_tag ct ON r.rev_id = ct.ct_rev_id
    JOIN change_tag_def ctd ON ct.ct_tag_id = ctd.ctd_id AND ctd.ctd_name = 'contenttranslation'
    LEFT JOIN actor a ON r.rev_actor = a.actor_id
    LEFT JOIN babel b ON a.actor_user = b.babel_user
    GROUP BY r.rev_actor
) AS subquery
WHERE num_languages > 0;
SQL

Checking query status...
