block/edit status of users listed on page

Of the user pages linked from [[User:WhatamIdoing/Student accounts in 2023]], shows:
* The total number of users
* The number of users with at least one edit
* The number of users who have ever been blocked (or reblocked) sitewide
* The number of users who have ever been blocked (or reblocked) sitewide in 2023
* The number of users who have ever been blocked (or reblocked) sitewide and have at least one edit
* The number of users who have ever been blocked (or reblocked) sitewide in 2023 and have at least one edit (ever)

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

SQL

SELECT COUNT(DISTINCT user_name) AS '#',
       COUNT(DISTINCT IF(user_editcount >= 1, user_name, NULL)) AS '# ever edited',
       COUNT(DISTINCT IF(log_id IS NOT NULL, user_name, NULL)) AS '# ever blocked',
       COUNT(DISTINCT IF(COALESCE(log_timestamp, '') LIKE '2023%', user_name, NULL)) AS '# blocked in 2023',
       COUNT(DISTINCT IF(user_editcount >= 1 AND log_id IS NOT NULL, user_name, NULL)) AS '# ever edited and ever blocked',
       COUNT(DISTINCT IF(user_editcount >= 1 AND COALESCE(log_timestamp, '') LIKE '2023%', user_name, NULL)) AS '# ever edited and blocked in 2023'
FROM page
JOIN pagelinks ON pl_from = page_id
JOIN user ON user_name = REPLACE(pl_title, '_', ' ')
LEFT JOIN logging_logindex
  ON log_namespace = 2 AND log_title = pl_title
  AND log_type = 'block'
  AND log_action IN ('block', 'reblock')
  AND log_params LIKE '%"sitewide";b:1%'
WHERE page_namespace = 2
  AND page_title = 'WhatamIdoing/Student_accounts_in_2023'
  AND pl_namespace = 2;

SQL

Checking query status...