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
#LEFT JOIN comment c1 ON b1.revcomment_comment_id = c1.comment_id
#WHERE b1.revcomment_rev > 949623000 and b1.revcomment_comment_id like "%[[WP:EPH|EPH]]%" group by b1.revcomment_comment_id

SELECT count(*) FROM revision_comment_temp c1
INNER JOIN `comment` c2 ON c2.comment_id = c1.revcomment_comment_id
WHERE c.comment_text like "%[[WP:EPH|EPH]]%";
SQL

Checking query status...
