Untitled query #74250

SQL

SELECT COUNT(*) AS user_count
FROM (
  SELECT e.user_id, e.num_edits, l.num_languages
  FROM (
    SELECT r.rev_actor AS user_id, COUNT(DISTINCT r.rev_id) AS num_edits
    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'
    GROUP BY r.rev_actor
  ) e
  JOIN (
    SELECT a.actor_user AS user_id, COUNT(DISTINCT b.babel_lang) AS num_languages
    FROM actor a
    LEFT JOIN babel b ON a.actor_user = b.babel_user
    GROUP BY a.actor_user
  ) l ON e.user_id = l.user_id
) AS subquery;
SQL

Checking query status...
