Untitled query #43693

SQL

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(*), actor_id from revision_actor_temp where rev_id > 595323656 and rev_comment like "%[[WP:EPH|EPH]]%" group by actor_id;
#select count(*), revactor_rev from revision_actor_temp where revactor_rev > 949623827;
#DESCRIBE revision;
#DESCRIBE revision_actor_temp;
#select count(*), revactor_actor from revision_actor_temp where rev_id > 949623000 and rev_comment like "%[[WP:EPH|EPH]]%" group by revcomment_comment_id;
SELECT count(*) FROM revision_actor_temp a1
INNER JOIN revision_comment_temp b1 ON a1.revactor_rev = b1.revcomment_rev
INNER JOIN comment c ON b.revcomment_comment_id = c.comment_id
WHERE b1.revcomment_rev > 949623000 and b1.revcomment_comment_id like "%[[WP:EPH|EPH]]%" group by c.revcomment_comment_id
SQL

Checking query status...
