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
   AND (
    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 gug_group != "global-ipblock-exempt"
  )
  AND "bot" not in (
    select ug_group
    from user_groups
    where ug_user = rev_user
  )
  AND "filemover" not in (
    select ug_group
    from commonswiki_p.user_groups
    where ug_user = rev_user
  )
  GROUP BY rev_user_text
)
ORDER BY number DESC
SQL

Checking query status...
