SQL
AخA
SET STATEMENT max_statement_time = 600 FOR
SELECT DISTINCT
actor_name,
rc_this_oldid,
comment_text
FROM
recentchanges_userindex AS recentchanges
INNER JOIN comment_recentchanges AS comment ON recentchanges.rc_comment_id = comment.comment_id
INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
WHERE
TRUE
AND rc_namespace = 0
AND rc_bot = 0
AND actor_name IS NOT NULL
AND comment_text = 'w\''
ORDER BY rc_timestamp DESC;
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.