Enregistrés en 2017 et actifs en 2023

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'
GROUP BY user_name
HAVING user_editcount > 8000
ORDER BY user_registration;
SQL

Checking query status...
