Research:Daily main namespace pages created by autopatrolled users
Daily main namespace pages created by autopatrolled users is a standardized metric used to measure the number of non-redirecting pages that are created in the main namespace (
page_namespace == 0) by users whose page creations do not require patrol/review on a given day.
The definition of an "autopatrolled" user depends on the configuration of a given wiki. Administrators and bots are generally two groups that always have this right, while others may or may not. The example SQL query is designed to work on the English Wikipedia and will have to be adapted to work with other wikis.
As this is a daily metric, a full 24 hours must elapse after the beginning of the date (UTC) in order to calculate an uncensored value.