Untitled query #4942

SQL

#from https://quarry.wmflabs.org/query/4795
USE ptwiki_p;
#should be: number of VE edits made by user who have made >100 total edits in past month
select r.rc_user userc, r.rc_user_text userd, count(r.rc_id) ve_edits 
from recentchanges r join tag_summary t on r.rc_id = t.ts_rc_id 
where t.ts_tags like "%visualeditor%" 
and r.rc_user in 
	(select usera from 
 		(select r.rc_user usera, count(r.rc_id) all_edits 
  		from recentchanges r 
  		where r.rc_user != 0 
  	group by r.rc_user) as tmp1 
 where all_edits > 100) group by userc order by userd;
SQL

Checking query status...
