Blocked UPEs on enwiki

Fork of Blocked UPEs on enwiki by Novem Linguae

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

SQL

SELECT actor_name AS blocking_admin, log_title AS blocked_user, comment_text AS block_reason, log_timestamp
FROM logging
JOIN comment_logging ON log_comment_id = comment_id
JOIN actor ON log_actor = actor_id
WHERE log_action = 'block'
AND (
  comment_text LIKE '%ndisclosed paid%'
  OR comment_text LIKE '%UPE%'   # LIKE doesn't appear to be case sensitive. careful of false positives such as "super"
)
AND log_actor != 198977042   # proxy blocking bot
AND log_id > 141016300   # only check logs after Jan 1, 2024
ORDER BY log_id ASC

SQL

Checking query status...