Untitled query #3127

SQL

use idwiki_p;

SELECT articles.user_name, COUNT(articles.user_name) AS excitement FROM
  ( SELECT
      page_id,
      page_namespace,
      page_title,
      MAX(ct_rev_id),
      ct_params,
      user_name,
      rev_timestamp
    FROM
      `change_tag`,
      `revision`,
      `user`,
      `page`
    WHERE
      page_namespace = 0 AND
      rev_timestamp BETWEEN 20150101000000 AND 20150401000000 AND
      ct_tag = 'contenttranslation' AND
      rev_id = ct_rev_id AND
      rev_page = page_id AND
      rev_user = user_id
    GROUP BY page_id, rev_timestamp
    ORDER BY NULL
  ) AS articles
GROUP BY articles.user_name
HAVING excitement > 1
ORDER BY excitement;
SQL

Checking query status...
