marathon whatever MMXVII

SQL

USE ukwiki_p;
SELECT CONCAT("[[User:", r.rev_user_text, "]]") as `user`, r.rev_user,
(
  select count(*)
  from revision_userindex as rr
  where rr.rev_user = r.rev_user
  and rr.rev_timestamp between 20170501210000 and 20171231215959
  group by rr.rev_user
) AS since_may,
(
  select count(*)
  from revision_userindex as rr
  where rr.rev_user = r.rev_user
  and rr.rev_timestamp between 20170801210000 and 20171231215959
  group by rr.rev_user
) AS since_august,
(
  select count(*)
  from revision_userindex as rr
  where rr.rev_user = r.rev_user
  and rr.rev_timestamp between 20010101010000 and 20170127215959
  group by rr.rev_user
) AS before_start
FROM revision_userindex AS r
JOIN page ON r.rev_page = page_id
WHERE r.rev_timestamp BETWEEN 20170127220000 AND 20170130215959
AND page_namespace = 0
AND rev_parent_id = 0
AND page_is_redirect = 0
GROUP BY r.rev_user
ORDER BY before_start ASC
SQL

Checking query status...
