Data envy workbook May 20 2016

Fork of Highly active editors who use the Visual Editor by Jmorgan (WMF)

This query is marked as a draft This query has been published by Jmorgan (WMF).

SQL

#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
    
#select * from enwiki_p.change_tag limit 100,10;

select * from enwiki_p.change_tag AS ct JOIN enwiki_p.revision AS r 
ON ct.ct_rev_id = r.rev_id WHERE ct_rev_id = 710408179;

#select * from enwiki_p.recentchanges where rc_id = 807266372;

SQL

Checking query status...