Untitled query #54618

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 "%দৃশ্যমান_সম্পাদনা%" 
     	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 > 100 order by all_edits desc
    ) active_editors 
    on ve_editors.userid = active_editors.userid order by percent_ve desc;
SQL

Checking query status...
