Blocked socks on enwiki (with edit count and past groups)

Fork of Blocked socks on enwiki (with edit count) by AntiCompositeNumber

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_logindex
JOIN comment_logging ON log_comment_id = comment_id
#JOIN actor_logging ON log_actor = actor_id
#JOIN `user` ON log_namespace = 2 AND user_name = REPLACE(log_title, "_", " ")
#JOIN user_former_groups ON ufg_user = user_id
WHERE 
	log_type = 'block' 
	AND log_action = 'block'
	AND (
  		comment_text LIKE '%Sockpuppet_investigations%'
  		OR comment_text LIKE '%WP:SOCK%'
	)
	AND log_actor != 198977042   # proxy blocking bot
	AND log_timestamp > DATE_SUB(NOW(), INTERVAL 1 MONTH)   # only check logs after Jan 1, 2023
#GROUP BY user_id
ORDER BY log_timestamp DESC

SQL

Checking query status...