This query is marked as a draft This query has been published by Mdaniels5757.

SQL

x
 
USE enwiki_p;
# (orig) select count(*), rev_user_text from revision where rev_id > 595323656 and rev_comment like "%[[WP:EPH|EPH]]%" group by rev_user_text;
#select count(*), rev_user_text from revision where rev_id > 595323656 and rev_comment like "%[[WP:EPH|EPH]]%" group by rev_user_text;
#SELECT COUNT(*), revactor_actor
#FROM revision INNER JOIN revision_actor_temp ON rev_id = revactor_rev
#WHERE rev_id > 595323656 AND rev_comment LIKE "%[[WP:EPH|EPH]]%" GROUP BY revactor_actor;
DESCRIBE revision_comment_temp;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...