Third-party ArbCom blocks

Fork of Third-party ArbCom blocks since Jan 1, 2020 by RoySmith

This query is marked as a draft This query has been published by RoySmith.

SQL

select log_id, log_action, date_format(log_timestamp, '%Y-%b-%d %H:%i:%s'), comment_text from logging, comment
where
log_comment_id = comment_id
and lower(convert(comment_text using utf8mb4)) like '%arbcom%'
and (lower(convert(comment_text using utf8mb4)) like '%consult%' or
     lower(convert(comment_text using utf8mb4)) like '%appeal%')
and lower(convert(comment_text using utf8mb4)) not like '%{{arbcom%'
and log_type = 'block'
and log_action != 'unblock'
-- and log_timestamp > concat('2022', '01', '00', '00', '00', '00')
;

SQL

Checking query status...