Blocked UPEs on enwiki in the last year

SQL

SELECT actor_name AS blocking_admin,
	log_title AS blocked_user,
    comment_text AS block_reason,
    log_timestamp
# logging_logindex is a little-known alternative view, but was the key to getting this to not timeout
FROM logging_logindex
# don't forget these alternative views too (comment_logging, actor_logging)
JOIN comment_logging ON log_comment_id = comment_id
JOIN actor_logging ON log_actor = actor_id
WHERE log_action = 'block'
AND (
    # LIKE is case sensitive on binary fields, unless you use `USING utf8mb4` to convert these fields to UTF-8
    comment_text LIKE '%ndisclosed paid%'
    OR comment_text LIKE '%upe%'
    OR comment_text LIKE '%UPE%'
)
AND log_actor != 198977042   # proxy blocking bot
AND log_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), "%Y%m%d%H%i%s")
# the below is redundant since the primary key is log_id. doesn't hurt to leave it in though
ORDER BY log_id ASC
SQL

Checking query status...
