Untitled query #55043

SQL

SELECT
  actor_name,
  STR_TO_DATE(LEFT(MIN(rev_timestamp), 8), '%Y%m%d'),
  SUM(
    CASE
      WHEN rev_len BETWEEN 0 AND 2048 THEN 1
      ELSE 0
    END
  ),
  SUM(
    CASE
      WHEN rev_len BETWEEN 2048 AND 15 * 1024 THEN 1
      ELSE 0
    END
  ),
  SUM(
    CASE
      WHEN rev_len BETWEEN 15 * 1024 AND 70 * 1024 THEN 1
      ELSE 0
    END
  ),
  SUM(
    CASE
      WHEN rev_len > 70 * 1024 THEN 1
      ELSE 0
    END
  ),
  COUNT(rev_first) tot
FROM revision_userindex r
JOIN (
  SELECT
    MIN(rev_id) rev_first,
    rev_page
  FROM revision
  GROUP BY rev_page
) f
  ON r.rev_id = f.rev_first
JOIN page
  ON page_id = r.rev_page
JOIN actor
  ON rev_actor = actor_id
LEFT JOIN user_groups
  on actor_user = ug_user
  AND ug_group = "bot"
WHERE
  actor_user <> 0
  AND ug_group IS NULL
  AND page_namespace = 0
  AND page_is_redirect = 0
GROUP BY actor_user
ORDER BY tot DESC
LIMIT 200
SQL

Checking query status...
