Total mainspace creations by timerange

Number of pages created in the main namespace over the last 7, 30, 90, and 180 days.  Does not include pages created elsewhere and then moved to mainspace.

See also query #76256.

For [[WP:VPI#Patrolling a random sample of edits by autopatrolled editors]] circa 30 Aug 2023.

SQL

SET @minus_7  = DATE_FORMAT(NOW() - INTERVAL 7 DAY, '%Y%m%d%H%i%s');
SET @minus_30 = DATE_FORMAT(NOW() - INTERVAL 30 DAY, '%Y%m%d%H%i%s');
SET @minus_90 = DATE_FORMAT(NOW() - INTERVAL 90 DAY, '%Y%m%d%H%i%s');
SET @minus_180 = DATE_FORMAT(NOW() - INTERVAL 180 DAY, '%Y%m%d%H%i%s');

SELECT COUNT(CASE WHEN log_timestamp >= @minus_7 THEN 1 ELSE NULL END) AS '7 days',
       COUNT(CASE WHEN log_timestamp >= @minus_30 THEN 1 ELSE NULL END) AS '30 days',
       COUNT(CASE WHEN log_timestamp >= @minus_90 THEN 1 ELSE NULL END) AS '90 days',
       COUNT(CASE WHEN log_timestamp >= @minus_180 THEN 1 ELSE NULL END) AS '180 days'
FROM logging_logindex
WHERE log_type = 'create' AND log_action = 'create'
  AND log_timestamp >= @minus_180
  AND log_namespace = 0;

SQL

Checking query status...