Users banned for threats in ruwiki

SQL

USE ruwiki_p;
SELECT
  admin.user_name as 'admin name',
--  log_namespace,
  log_timestamp as 'time',
--  log_action,
  REPLACE(log_title, '_', ' ') as 'blocked name',
  (SELECT
    blocked.user_editcount
   FROM user AS blocked
   WHERE
     blocked.user_name = REPLACE(log_title, '_', ' ')
  ),
  (SELECT
    blocked.user_registration as 'blocked 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 >= "20160101"
ORDER BY log_timestamp DESC
;
SQL

Checking query status...
