attempt at something (1)

Fork of Blocked UPEs on enwiki (with edit count) by Hey man im josh

This query is marked as a draft This query has been published by Hey man im josh.

SQL

SELECT actor_name AS blocking_admin, log_title AS blocked_user, comment_text AS block_reason, log_timestamp, user_editcount, COUNT(ufg_group)
FROM logging_userindex
JOIN comment_logging ON log_comment_id = comment_id
JOIN actor_logging ON log_actor = actor_id
JOIN `user` ON log_title = user_name AND log_namespace = 2
JOIN user_former_groups ON ufg_user = user_id
WHERE log_action = 'block'
AND (
  comment_text LIKE '%Sockpuppet investigations%'
  OR comment_text LIKE '%WP:SOCK%'
)
AND log_actor != 198977042   # proxy blocking bot
AND log_id > 141016300   # only check logs after Jan 1, 2023
GROUP BY user_id
ORDER BY log_id DESC

SQL

Checking query status...