SELECT

    r.rev_timestamp AS Datum,

    CONVERT(a.actor_name USING utf8) AS Aanmaker,

    CONVERT(p.page_title USING utf8) AS Titel,

    GROUP_CONCAT(ug.ug_group SEPARATOR ', ') AS Gebruikersgroepen

FROM revision r

JOIN actor a ON r.rev_actor = a.actor_id

LEFT JOIN page p ON r.rev_page = p.page_id

LEFT JOIN user u ON a.actor_user = u.user_id

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

WHERE r.rev_parent_id = 0

  AND r.rev_timestamp BETWEEN '20250101000000' AND '20250225235959'

  AND (p.page_id IS NULL OR p.page_namespace = 0)

GROUP BY r.rev_id

ORDER BY r.rev_timestamp DESC

LIMIT 1000;

​