Admins : date d'inscription

SQL

SELECT
  user_name,
  user_editcount,
  DATE_FORMAT(STR_TO_DATE(SUBSTRING(user_registration, 1, 8), '%Y%m%d'), '%d-%m-%Y') AS 'Date d\'inscription (JJ-MM-AAAA)',
  DATE_FORMAT(STR_TO_DATE(SUBSTRING(MAX(rev_timestamp), 1, 8), '%Y%m%d'), '%d-%m-%Y') AS 'Dernière modification'
FROM `user`
LEFT JOIN user_groups ug1
  ON user_id = ug1.ug_user
JOIN actor
  ON actor_user = user_id
JOIN revision_userindex
  ON rev_id = (SELECT rev_id FROM revision_userindex
               WHERE actor_id = rev_actor
               ORDER BY rev_timestamp DESC
               LIMIT 1)
WHERE rev_timestamp >= '2023-01-01'
  AND user_registration >= '2017-01-01'
  AND NOT ug1.ug_group = 'sysop' -- Exclure les utilisateurs dont le groupe est "sysop"
GROUP BY user_name
HAVING user_editcount > 8000
ORDER BY user_registration;
SQL

Checking query status...
