SELECT log_user_text AS `reviewer`,

       COUNT(DISTINCT(log_page)) AS `reviews`

FROM enwiki_p.logging_userindex

WHERE log_timestamp BETWEEN 20170521000000 AND 20170621000000

AND NOT log_timestamp BETWEEN 20170614000000 AND 20170621000000

AND log_namespace = 0

AND (

  (

    log_type = 'patrol'

    AND log_action = 'patrol'

  ) OR (

    log_type = 'pagetriage-curation'

    AND log_action = 'reviewed'

  )

)

GROUP BY reviewer

ORDER BY reviews DESC;