SELECT LEFT(log_timestamp,6), COUNT(*)

FROM logging

LEFT JOIN page ON page_id = log_page

LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'disambiguation'

JOIN actor_logging ON actor_id = log_actor

JOIN user ON user_id = actor_user

WHERE log_type = 'create'

  AND log_timestamp >= '202107'

  AND log_namespace = 0

  AND COALESCE(page_is_redirect, 0) = 0

  AND pp_page IS NULL

  AND TIMEDIFF(CAST(log_timestamp AS DATETIME) - INTERVAL 90 DAY, CAST(user_registration AS DATETIME)) <= 0

GROUP BY LEFT(log_timestamp,6)

ORDER BY log_timestamp ASC;