Untitled query #74250

SQL

WITH cte_edits AS (
  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
),
cte_languages AS (
  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
)
SELECT e.user_id, e.num_edits, l.num_languages
FROM cte_edits e
JOIN cte_languages l ON e.user_id = l.user_id;
SQL

Checking query status...
