Users using the old toolbar

SQL

# from matmarex
use enwikisource;
# select count(distinct rc_user) from recentchanges;
select count(*) from (
select * from (
select
  t.up_user,
  cast(user_properties_showtoolbar.up_value as char) as showtoolbar,
  cast(user_properties_usebetatoolbar.up_value as char) as usebetatoolbar,
  count(rc_user) as recent_edits
from (
select distinct up_user from user_properties
where up_property in ('showtoolbar', 'usebetatoolbar')
) t
left join user_properties as user_properties_showtoolbar
  on t.up_user=user_properties_showtoolbar.up_user and user_properties_showtoolbar.up_property = 'showtoolbar'
left join user_properties as user_properties_usebetatoolbar
  on t.up_user=user_properties_usebetatoolbar.up_user and user_properties_usebetatoolbar.up_property = 'usebetatoolbar'
left join recentchanges on rc_user=t.up_user
left join user on user_id=t.up_user
group by up_user
) u
where usebetatoolbar is not null
and showtoolbar is null
order by recent_edits desc
) v
where recent_edits > 0
SQL

Checking query status...
