ukwiki users by registration year (without bots)

SQL

use ukwiki_p;
select count(user_name) as users50, 
count(case when user_editcount >= 100 then 1 else null end) as users100,
count(case when user_editcount >= 500 then 1 else null end) as users500,
count(case when user_editcount >= 1000 then 1 else null end) as users1000, 
count(case when user_editcount >= 5000 then 1 else null end) as users5000,
coalesce(year(user_registration), 0) as year
from user
where user_editcount >= 50
and coalesce (
  (select 'Y' from user_groups ug where ug.ug_user = u.user_id and ug.ug_group = 'bot' limit 1),
  (select 'Y' from user_former_groups ufg where ufg.ufg_user = u.user_id and ufg.ufg_group = 'bot' limit 1),
  'N'
) = 'N'
and user_name not like '%bot'
and user_name not like '%Bot'
group by year
order by year asc;
SQL

Checking query status...
