Users banned for threats in ruwiki

SQL

USE ruwiki_p;
SELECT
  admin.user_name,
--  log_namespace,
  log_timestamp,
--  log_action,
  log_title,
  blocked.user_editcount,
  blocked.user_registration,
--  log_comment,
  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 >= "20180101"

SQL

Checking query status...