users by interface language in ruwiki

SQL

select
up_value,
count(*) as over1edit,
count(case when user_editcount > 10 then 1 else null end) as over10edits,
count(case when user_editcount > 100 then 1 else null end) as over100edits,
count(case when user_editcount > 1000 then 1 else null end) as over1000edits,
count(case when user_editcount > 10000 then 1 else null end) as over10000edits
from ruwiki_p.user_properties
join ruwiki_p.user on up_user = user_id
where up_property = "language" and user_editcount > 1
group by up_value
order by over1edit desc

SQL

Checking query status...