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;