edits by user day by day

SQL

USE fawiki_p;
SELECT
  actor_name,
  LEFT(rev_timestamp, 8),
  COUNT(*)
FROM revision
JOIN actor
  ON rev_actor = actor_id
WHERE
  rev_actor IN
  (
    SELECT rev_actor
    FROM revision
    JOIN actor
      ON rev_actor = actor_id
      AND actor_user <> 0
    LEFT JOIN user_groups
      ON ug_user = actor_user
      AND ug_group = 'bot'
    WHERE
      rev_timestamp > '20190901000000'
      AND ug_user IS NULL
      AND actor_name <> 'پیام به کاربر جدید'
    GROUP BY rev_actor
    HAVING COUNT(*) > 100
  )
  AND rev_timestamp > '20190901000000'
GROUP BY
  actor_name,
  LEFT(rev_timestamp, 8)
SQL

Checking query status...
