Blocks of article-creating new users by month

The number of users blocked each month since 2021/07 while no more than 90 days old, who had previously created at least one page in the main namespace which (if still existing) is not a redirect or dab.  (Pages created outside of the main namespace and then moved there don't qualify.)

Each user is counted no more than once, even if unblocked and then reblocked. Users blocked more than once are listed by the first month in the time range they were blocked (so a user who was blocked before 2021/07, then unblocked, then blocked a second time during or after 2021/07 (but still less than 90 days since their registration) will instead be listed in the month of their second block).

For [[WP:RAQ#For NPP]] circa 20 Aug 2022.

SQL

SELECT yearmonth, COUNT(user_name)
FROM
(
SELECT LEFT(MIN(blocked.log_timestamp),6) AS `yearmonth`, user_name
FROM logging AS blocked
JOIN user ON user_name = log_title
WHERE log_type = 'block'
  AND log_timestamp >= '202107'
  AND log_type = 'block'
  AND log_action = 'block'
  AND TIMEDIFF(CAST(log_timestamp AS DATETIME) - INTERVAL 90 DAY, CAST(user_registration AS DATETIME)) <= 0
  AND EXISTS (SELECT 1
              FROM logging_userindex AS creation
              JOIN actor_logging ON actor_id = creation.log_actor
              LEFT JOIN page ON page_id = creation.log_page
              LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'disambiguation'
              WHERE log_type = 'create'
                AND log_namespace = 0
                AND COALESCE(page_is_redirect, 0) = 0
                AND pp_page IS NULL
                AND actor_user = user_id
                AND creation.log_timestamp < blocked.log_timestamp)
GROUP BY user_name
) sq
GROUP BY yearmonth
ORDER BY yearmonth ASC;

SQL

Checking query status...