Query Run
use enwiki_p; select count(rc_id) as reviews, SUM(comment_text like... 12 months ago
use enwiki_p; select count(rc_id) as reviews, SUM(comment_text like... 3 years ago
use enwiki_p; select ROW_NUMBER() OVER(ORDER BY reviews DESC) AS rank, ... 3 years ago
use enwiki_p; select ROW_NUMBER() OVER(ORDER BY reviews DESC) AS rank, ... 3 years ago
use enwiki_p; select ROW_NUMBER() OVER(ORDER BY reviews DESC) AS rank, ... 3 years ago