Jeeputer - fawiki Users with most edits in the past month (including bots and IPs)

Fork of Users with most edits in the past month (including bots and IPs) by DHN

This query is marked as a draft This query has been published by Jeeputer.

SQL

SELECT
  actor.actor_name AS کاربر,
  GROUP_CONCAT(DISTINCT user_groups.ug_group) AS اختیارات,
  COUNT(DISTINCT rev_id) AS تعداد
FROM revision LEFT JOIN actor ON (revision.rev_actor = actor.actor_id)
  LEFT JOIN user_groups ON (actor.actor_user = user_groups.ug_user)
-- پالایش بر پایه زمان
WHERE DATEDIFF(CURDATE(), rev_timestamp) < 30
-- گروه‌بندی بر پایه کاربر.
GROUP BY کاربر
-- محدود به ۲۰۰ کاربر با بیشترین تعداد ویرایش
ORDER BY تعداد DESC
LIMIT 200;

SQL

Checking query status...