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_groups ON ug_user = actor_user AND ug_group = 'autoreviewer'

WHERE log_type = 'create'

  AND log_timestamp >= '202107'

  AND log_namespace = 0

  AND COALESCE(page_is_redirect, 0) = 0

  AND pp_page IS NULL

GROUP BY LEFT(log_timestamp,6)

ORDER BY log_timestamp ASC;