Fork of
Comment search recent (rd)
by Spicy
This query is marked as a draft
This query has been published
by Blablubbs.
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 LIKE '%Qatar%'
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.
Query status: complete
Executed in 92.54 seconds as of Mon, 15 Aug 2022 10:48:51 UTC.