Faebot trimmer activity by platform

SQL

USE commonswiki_p;
SELECT page_title,
	SUBSTR(	comment_text, INSTR(comment_text,'(') + 1, LENGTH(comment_text) - INSTR(comment_text,'(') - 1 ) AS Comment,
	LEFT(rev_timestamp,10) AS Date
FROM page
JOIN revision_userindex ON page_id=rev_page	AND DATEDIFF(CURRENT_TIMESTAMP, rev_timestamp) < 8
JOIN comment_revision ON comment_id = rev_comment_id
JOIN actor_revision ON rev_actor = actor_id AND actor_name="Faebot"
WHERE comment_text LIKE "[[User talk:Fae/talk page trimmer%"
AND comment_text LIKE "%(%"
AND page_namespace = 3
ORDER BY Date DESC
LIMIT 24;

SQL

Checking query status...