SELECT 

  u.user_name,

  COUNT(*) AS edit_count

FROM revision r

JOIN page p ON r.rev_page = p.page_id

JOIN actor a ON r.rev_actor = a.actor_id

JOIN user u ON a.actor_user = u.user_id

LEFT JOIN user_groups ug ON u.user_id = ug.ug_user

JOIN categorylinks cl ON p.page_id = cl.cl_from

WHERE cl.cl_to = 'Naissance_vivante'  -- Category for living persons (adjust if necessary)

  AND r.rev_timestamp >= '20231001000000'  -- Since October 2023

  AND r.rev_timestamp <= '20241231235959'

  AND u.user_id NOT IN (

    SELECT ug_user

    FROM user_groups

    WHERE ug_group = 'sysop'

  )

  AND EXISTS (

    SELECT 1

    FROM revision_text rt

    WHERE rt.rev_id = r.rev_id

      AND (rt.rev_text LIKE '%juif%' OR rt.rev_text LIKE '%juive%')

  )

GROUP BY u.user_name

ORDER BY edit_count DESC

LIMIT 200;

​