moves and patrols by ug (20 Jul 2024)

Fork of moves and patrols (20 Jul 2024) by Cryptic

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

Total number of page moves and page curations on 20 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.

The user group counts are by what groups the users are in *now*, not when they made the moves or curations.

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

SQL

SELECT COUNT(*),
       SUM(NOT EXISTS(SELECT 1
                      FROM user_groups
                      WHERE ug_user = actor_user AND ug_group IN ('extendedconfirmed', 'sysop', 'bot')
                      LIMIT 1)) AS '# done by non-extcfd',
       IF(log_namespace = 0, 'mainspace', 'non-mainspace') AS 'namespace',
       log_type
FROM logging
JOIN actor_logging ON actor_id = log_actor
WHERE log_timestamp LIKE '20240720%'
  AND (log_type = 'move'
       OR (log_type = 'pagetriage-curation' AND log_action IN ('reviewed', 'reviewed-article', 'reviewed-redirect')))
GROUP BY 3, 4;

AخA
 
SELECT COUNT(*),       SUM(NOT EXISTS(SELECT 1                      FROM user_groups                      WHERE ug_user = actor_user AND ug_group IN ('extendedconfirmed', 'sysop', 'bot')                      LIMIT 1)) AS '# done by non-extcfd',       IF(log_namespace = 0, 'mainspace', 'non-mainspace') AS 'namespace',       log_typeFROM loggingJOIN actor_logging ON actor_id = log_actorWHERE log_timestamp LIKE '20240720%'  AND (log_type = 'move'       OR (log_type = 'pagetriage-curation' AND log_action IN ('reviewed', 'reviewed-article', 'reviewed-redirect')))GROUP BY 3, 4;

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...