SQL
AخA
SELECT rc_user_text AS user,
Count(rc_id) AS cnt,
Count(rc_id) / 15 AS EPM,
max(rc_timestamp) AS last_change,
comment_text AS last_editsum
FROM recentchanges_userindex
join comment on rc_comment_id = comment_id
WHERE rc_timestamp >= Date_sub(Now(), INTERVAL 15 minute)
AND rc_bot != 1
AND ( rc_type = 0
OR rc_type = 1 )
GROUP BY rc_user_text
HAVING EPM > 1
ORDER BY cnt DESC;
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.