moves and patrols (Jul 2024)

Total number of page moves and page curations in July 2024.
See [[Wikipedia:Request a query/Archive 4#How do the patrol/pagetriage-curation logs really work?]] for why querying for log_type = 'patrol' is misleading.

namespace=mainspace or not is determined by the page's pre-move title for cross-namespace moves.  Querying for the destination is difficult; it's stored only as a full title in the middle of a string of serialized php data, like 'a:3:{s:9:"4::target";s:20:"Draft:Mehran Tebyani";s:10:"5::noredir";s:1:"1";s:17:"associated_rev_id";i:1235738015;}'.  Moves to specific non-main namespaces could conceivably be found, but parsing that in sql for the lack of a namespace name isn't feasible.

For [[WP:VPR#Does the community still want moved pages to be unreviewed]] circa 21 July 2024.

SQL

SELECT COUNT(*),
       IF(log_namespace = 0, 'mainspace', 'non-mainspace') AS 'namespace',
       log_type
FROM logging
WHERE log_timestamp LIKE '202407%'
  AND (log_type = 'move'
       OR (log_type = 'pagetriage-curation' AND log_action IN ('reviewed', 'reviewed-article', 'reviewed-redirect')))
GROUP BY log_namespace = 0 DESC, log_type;

AخA
 
SELECT COUNT(*),       IF(log_namespace = 0, 'mainspace', 'non-mainspace') AS 'namespace',       log_typeFROM loggingWHERE log_timestamp LIKE '202407%'  AND (log_type = 'move'       OR (log_type = 'pagetriage-curation' AND log_action IN ('reviewed', 'reviewed-article', 'reviewed-redirect')))GROUP BY log_namespace = 0 DESC, log_type;

SQL

Checking query status...