Total mainspace creations by timerange

This query is marked as a draft This query has been published by Cryptic.

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;

​x
 
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_logindexWHERE log_type = 'create' AND log_action = 'create'  AND log_timestamp >= @minus_180  AND log_namespace = 0;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...