SQL
AخA
use huwiki_p;
SELECT
log_user_text user,
count(*) as review_cnt
FROM
logging
WHERE
log_type = 'review'
AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i')
AND log_timestamp > '20170101000000' and log_timestamp<'20180101000000'
GROUP BY log_user
ORDER BY review_cnt DESC
LIMIT 25
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.