Users using the old toolbar

SQL

# from matmarex https://phabricator.wikimedia.org/T30856#3356012
use enwiki_p;
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_actor) as recent_edits
from (
-- select count(distinct rc_actor) from recentchanges
-- join actor ON rc_actor = actor_id
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_actor = 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...
