Faebot trimmer activity by platform

Fork of Faebot trimmer activity by platform by Fæ

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

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" OR actor_name="Fæ"
WHERE comment_text LIKE "%(User talk:Fæ/IA books#Fork%" AND comment_text LIKE "%(%"
AND page_namespace = 6
ORDER BY Date DESC
LIMIT 24;

SQL

Checking query status...