T357580 - frwiki transition for site/user scripts between Vector and Vector 2022 skins

This SQL retrieves the names of active users (in the user discussion namespace) who have made recent changes (since may 2023 ; generalization of Vector 2022) and have vector.js/vector.css pages. We can send them a MassMessage.

SQL

SELECT DISTINCT(p.page_title),
       CASE
           WHEN a.actor_name IS NULL THEN 'true'
           ELSE 'false'
       END AS redirect
FROM page AS p
LEFT JOIN actor AS a ON a.actor_name = REPLACE(SUBSTRING_INDEX(p.page_title, '/', 1), '_', ' ')
LEFT JOIN
  (SELECT rev_actor,
          MAX(rev_timestamp) AS max_timestamp
   FROM revision_userindex
   GROUP BY rev_actor) AS r ON r.rev_actor = a.actor_id
WHERE p.page_namespace = 2
  AND (p.page_title LIKE "%/vector.js"
       OR p.page_title LIKE "%/vector.css")
  AND p.page_len != 0
  AND r.max_timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 6 MONTH), '%Y%m%d%H%i%s');

SQL

Checking query status...