(

  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,

      'Neen' AS Verwijderd

  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 '20241201000000' AND '20241231235959'

    AND (p.page_id IS NULL OR (p.page_namespace = 0 AND p.page_is_redirect = 0)) -- Exclude redirects

  GROUP BY r.rev_id

)

UNION ALL

(

  SELECT

      ar.ar_timestamp AS Datum,

      CONVERT(a.actor_name USING utf8) AS Aanmaker,

      CONVERT(ar.ar_title USING utf8) AS Titel,

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

      'Ja' AS Verwijderd

  FROM archive ar

  JOIN actor a ON ar.ar_actor = a.actor_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 IFNULL(ar.ar_parent_id, 0) = 0

    AND ar.ar_timestamp BETWEEN '20241201000000' AND '20241231235959'

    AND ar.ar_namespace = 0

  GROUP BY ar.ar_id

)

ORDER BY Datum DESC;