Fork of
Comment search recent (rd)
by MarioGom
This query is marked as a draft
This query has been published
by Blablubbs.
SQL
AخA
SELECT DISTINCT
actor_name,
rc_this_oldid,
comment_text
FROM
recentchanges_userindex AS recentchanges
INNER JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
WHERE
rc_namespace = 0
AND rc_bot = 0
AND actor_name IS NOT NULL
AND comment_text RLIKE '%[sS]entence correction%'
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.