SELECT
  actor_name,
  SUM(
    CASE
      WHEN page_namespace = 0 THEN 1
      ELSE 0
    END
  ) article,
  SUM(
    CASE
      WHEN page_namespace = 10 THEN 1
      ELSE 0
    END
  ) tpl,
  SUM(
    CASE
      WHEN page_namespace = 12 THEN 1
      ELSE 0
    END
  ) helppage,
  SUM(
    CASE
      WHEN page_namespace = 14 THEN 1
      ELSE 0
    END
  ) cat,
  SUM(
    CASE
      WHEN page_namespace = 100 THEN 1
      ELSE 0
    END
  ) portal,
  COUNT(rev_first) tot
FROM revision 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 IN (
    0,
    10,
    12,
    14,
    100
  )
GROUP BY rev_actor
ORDER BY tot desc
LIMIT 300