SQL
AخA
SELECT page_id, rev_id, rev_user_text, rev_comment
FROM revision_userindex
INNER JOIN page ON rev_page = page_id
WHERE
rev_user_text NOT LIKE "%*bot%" OR
rev_user_text NOT LIKE "%*Bot&" AND
rev_timestamp BETWEEN "20170701" AND "20171231" AND
(rev_comment LIKE "%F*ck%" OR
rev_comment LIKE "%F*k%" OR
rev_comment LIKE "%fk%" OR
rev_comment LIKE "%fgseqw*%" OR
rev_comment LIKE "%* added truth%") AND
page_namespace = 0;
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.