marathon whatever MMXVII

SQL

SELECT r.rev_user_text, 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
FROM revision_userindex AS r
JOIN page ON r.rev_page = page_id
WHERE r.rev_timestamp BETWEEN 20170127220000 AND 20170130215959
GROUP BY r.rev_user
SQL

Checking query status...
