SQL
x
use cawiki_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
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.