Fork of
Untitled query #69443
by Rhododendrites
This query is marked as a draft
This query has been published
by Rhododendrites.
SQL
AخA
SELECT log_timestamp, log_id, actor_name, log_title, user_editcount, comment_text, log_params
FROM logging
LEFT JOIN user ON user_name = REPLACE(log_title, "_", " ")
JOIN actor ON log_actor = actor_id
JOIN comment ON log_comment_id = comment_id
WHERE log_type = "block"
AND log_action = "block"
AND log_timestamp > 20200101000000
AND (comment_text LIKE "%attack%" OR comment_text LIKE "%harass%" OR comment_text LIKE "%racis%" OR comment_text LIKE "%civil%"
OR comment_text LIKE "%sexis%" OR comment_text LIKE "%bigot%" OR comment_text LIKE "%WP:NPA%" OR comment_text LIKE "%insult%"
OR comment_text LIKE "%slur%" OR comment_text LIKE "%stereotyp%" OR comment_text LIKE "%bully%" OR comment_text LIKE "%WP:PA%"
OR comment_text LIKE "%WP:NOPA%" OR comment_text LIKE "%gravedanc%" OR comment_text LIKE "%aspersion%"
OR comment_text LIKE "%WP:HA%" OR comment_text LIKE "%hound%" OR comment_text LIKE "%following%" OR comment_text LIKE "%outing%"
OR comment_text LIKE "%dox%" OR comment_text LIKE "%offwiki%" OR comment_text LIKE "%off-wiki%" OR comment_text LIKE "%personaliz%"
OR comment_text LIKE "%personalis%")
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.