>=25 non-redir creations by user, calendar day

Users with at least 25 non-redirect mainspace creations in a given calendar day.

This examines pages by their current status: whether they exist and are a nonredirect and in mainspace *now*, rather than whether they were at creation.  Disambiguation pages, set index articles, and list articles are also not filtered out.

For [[Wikipedia talk:Arbitration Committee/Requests for comment/Article creation at scale#Comments by Cryptic]], in response to a question by [[User:WhatamIdoing]] in [[#Proposed solution 15: Clear definitions]], circa 5 September 2022.

SQL

SELECT actor_name, CAST(LEFT(log_timestamp, 8) AS DATE) AS `date`, COUNT(*)
FROM logging_logindex
JOIN actor_logging ON actor_id = log_actor
JOIN page ON page_id = log_page
WHERE log_type = 'create'
  AND log_timestamp >= '20180627' -- the date of the first creation log
  AND page_namespace = 0
  AND page_is_redirect = 0
GROUP BY actor_name, LEFT(log_timestamp, 8)
HAVING COUNT(*) >= 25;

AخA
 
SELECT actor_name, CAST(LEFT(log_timestamp, 8) AS DATE) AS `date`, COUNT(*)FROM logging_logindexJOIN actor_logging ON actor_id = log_actorJOIN page ON page_id = log_pageWHERE log_type = 'create'  AND log_timestamp >= '20180627' -- the date of the first creation log  AND page_namespace = 0  AND page_is_redirect = 0GROUP BY actor_name, LEFT(log_timestamp, 8)HAVING COUNT(*) >= 25;

SQL

Checking query status...