SELECT 

  u.user_name,

  p.page_title,

  r.rev_id,

  r.rev_timestamp,

  c.comment_text

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

JOIN comment c ON r.rev_comment_id = c.comment_id  -- Join to get edit summary

JOIN categorylinks cl ON p.page_id = cl.cl_from  -- Link to categories

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

  AND r.rev_timestamp <= '20241231235959'

  AND (c.comment_text LIKE '%juif%' OR c.comment_text LIKE '%juive%')  -- Search in edit summary

  AND (

    cl.cl_title LIKE '%Personnalité vivante%'  -- Category indicating living personality

    OR cl.cl_title LIKE '%biographie%'  -- Biographical category indicating living personalities

  )

ORDER BY r.rev_timestamp DESC

LIMIT 5;

​