Recent active newcomers who make a lot of VE article edits

Editors who have made at least 10 article namespace edits and joined within the past 7 days, sorted by the % of those edits that were made with VisualEditor. Last run on August 23, 2016. Fork and re-run to generate a fresh list.

SQL

 select ve_editors.username, ve_edits, all_edits, 100*(ve_edits/all_edits) percent_ve 
 	from 
 	(select distinct r.rc_user userid, r.rc_user_text username, count(r.rc_id) ve_edits 
     	from recentchanges r join tag_summary t on r.rc_id = t.ts_rc_id 
     		where r.rc_user != 0 and r.rc_bot = 0 and r.rc_namespace = 0 
     		and r.rc_source in ("mw.edit", "mw.new") and t.ts_tags like "%visualeditor%" 
     	group by userid
    ) ve_editors 
    join 
    (select r.rc_user userid, r.rc_user_text username, count(r.rc_id) all_edits 
  		from recentchanges r 
  			where r.rc_user != 0 and r.rc_bot = 0 and r.rc_namespace = 0 and r.rc_source in ("mw.edit", "mw.new")
  		group by r.rc_user having all_edits > 10 order by all_edits desc
    ) active_editors 
    on ve_editors.userid = active_editors.userid 
    join enwiki_p.user u
    on ve_editors.userid = u.user_id 
    where u.user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 7 DAY),'%Y%m%d%H%i%s')
    order by percent_ve desc;

SQL

Checking query status...