Users banned for threats in ruwiki

SQL

USE ruwiki_p;
SELECT
  admin.user_name as 'admin',
--  log_namespace,
  log_timestamp as 'time',
--  log_action,
  REPLACE(log_title, '_', ' ') as 'blocked',
  (SELECT 
    blocked.user_editcount,
    blocked.user_registration
   FROM user AS blocked
   WHERE
     blocked.user_name = REPLACE(log_title, '_', ' ')
  ),
  log_params
FROM logging
JOIN user AS admin ON log_user = admin.user_id
-- JOIN user AS blocked ON log_title = blocked.user_name
WHERE log_type = "block"
  AND log_action = "block"
  AND log_title NOT LIKE "%.%.%.%"
  AND log_title NOT LIKE "%:%:%:%:%:%:%:%"
  AND log_comment = "[[ВП:УГРОЗА|угрозы]]"
  AND log_timestamp >= "20180901"
SQL

Checking query status...
