Fork of
Faebot trimmer activity by platform
by Fæ
This query is marked as a draft
This query has been published
by ShakespeareFan00.
SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.