Untitled query #75891

SQL

SELECT DISTINCT rev_timestamp,comment_rev_comment.comment_text AS `rev_comment_text`,COUNT(DISTINCT page_title),user_name FROM `revision` FORCE INDEX (rev_actor_timestamp) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = rev_comment_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE comment_rev_comment.comment_text LIKE '#WPWP #WPWPARM' AND actor_name = '23artashes' LIMIT 1000
SQL

Checking query status...
