Query Run
select left(user_registration, 4) as year, avg(user_editcount) from user... 3 years ago
select left(log_timestamp, 4) as year, count(*) as count from logging where... 3 years ago
select count(*) from user where user_editcount>100 and... 3 years ago
select count(*) from user where user_editcount>100 and... 3 years ago
select count(*) from user where user_editcount>100 and... 3 years ago
select count(*) from cswiki_p.user where user_editcount>100 and... 3 years ago