Fork of
Untitled query #49049
by SQL
This query is marked as a draft
This query has been published
by SQL.
SQL
AخA
SELECT page_namespace,
page_title,
rc_timestamp,
rc_this_oldid,
comment_text
FROM comment_recentchanges
JOIN recentchanges
ON rc_comment_id = comment_id
JOIN page
ON page_id = rc_cur_id
WHERE ( Lower(comment_text) regexp '\\b(los(er|ing|ers|erloser)|how dare you block me!
|to do in quarantine|the unconstructive one|my quarantine activity|can in quarantine).*\\b' )
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.