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`
WHERE user_id NOT IN (
  SELECT ug_user
  FROM user_groups
  WHERE ug_group = 'sysop'
)
AND user_id IN (
  SELECT actor_user
  FROM actor
  WHERE actor_user = user_id
)
AND user_id IN (
  SELECT rev_actor
  FROM revision_userindex
  WHERE rev_timestamp >= '2023-01-01'
)
AND user_registration >= '2017-01-01'
GROUP BY user_name
HAVING user_editcount > 8000
ORDER BY user_registration;
SQL

Checking query status...
