2023 0 edit account block reason

Fork of Accounts created by year with 2023 blocks (0 edits) by BilledMammal

This query is marked as a draft This query has been published by BilledMammal.

The number of accounts created on enwiki in 2023 who have ever made an edit, and the number of them who have ever had a sitewide block.

For [[WP:RAQ#Number of blocks last year]] circa 2 February 2024.

SQL

WITH newusers(nu_name) AS
(
  SELECT user_name
  FROM user
  WHERE user_editcount = 0
  AND user_registration LIKE "2023%"
)

SELECT nu_name, comment_text
FROM newusers
JOIN logging_logindex ON log_namespace = 2 AND log_title = nu_name
JOIN comment ON comment_id = log_comment_id
WHERE log_type = 'block'
  AND log_timestamp LIKE "2023%"
  AND log_action IN ('block', 'reblock')
  AND log_params LIKE '%"sitewide";b:1%'

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...