Blocked UPEs on enwiki in the last year

Fork of Blocked UPEs on enwiki in the last year by Novem Linguae

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

SQL

SELECT 
    actor_name AS blocking_admin,
    log_title AS blocked_user,
    log_timestamp,
    CONVERT(ug.ug_group USING utf8) AS user_group
FROM logging
JOIN actor ON actor.actor_id = logging.log_actor
JOIN user_groups ug ON ug.ug_user = logging.log_title
WHERE log_action = 'block'
AND (
    log_comment LIKE '%ndisclosed paid%'
    OR log_comment LIKE '%upe%'
    OR log_comment LIKE '%UPE%'
)
AND actor.actor_user != 198977042
AND log_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), "%Y%m%d%H%i%s")
ORDER BY log_id ASC;

SQL

Checking query status...