Number of edits since beginning of the year by edits

SQL

USE ukwikiquote_p;
(
  SELECT "**TOTAL**" as rev_user_text, count(*) as number
  FROM revision_userindex
  WHERE rev_timestamp > 20170101000000
)
UNION ALL
(
  SELECT "**USERS**" as rev_user_text, count(DISTINCT r.rev_user_text) as number
  FROM revision_userindex r
  WHERE rev_timestamp > 20170101000000
--  AND "global-bot" not in (
--  	select gug_group
--    from centralauth_p.global_user_groups
--    join centralauth_p.globaluser on gug_user = gu_id
--    where gu_name = rev_user_text
--  )
--  AND "bot" not in (
--    select ug_group
--    from user_groups
--    where ug_user = rev_user
--  )
)
UNION ALL
(
  SELECT rev_user_text, count(*) as number
  FROM revision_userindex
  WHERE rev_timestamp > 20170101000000
  GROUP BY rev_user_text
)
ORDER BY number DESC
SQL

Checking query status...
