# Pastebin iJiYO4nm
    SELECT DISTINCT rl.gid AS release_mbid
                  , rl.name AS release_name
                  , rgpt.name AS release_group_primary_type
                  , rgst.name AS release_group_secondary_type
                  , sub.date_year || '-' || sub.date_month || '-' || sub.date_day AS date
                  , ac.name AS artist_credit_name
                  , array_agg(a.gid) AS artist_mbids
              FROM (
                    SELECT rc.release
                         , rc.date_year
                         , rc.date_month
                         , rc.date_day
                      FROM release_country rc
                     WHERE make_date(rc.date_year, rc.date_month, rc.date_day) >= '2022-05-15'
                       AND make_date(rc.date_year, rc.date_month, rc.date_day) <= '2022-06-15'
            UNION
                    SELECT ruc.release
                         , ruc.date_year
                         , ruc.date_month
                         , ruc.date_day
                      FROM release_country ruc
                     WHERE make_date(ruc.date_year, ruc.date_month, ruc.date_day) >= '2022-05-15'
                       AND make_date(ruc.date_year, ruc.date_month, ruc.date_day) <= '2022-06-15'
                   ) AS sub
              JOIN release rl
                ON rl.id = sub.release
              JOIN release_group rg
                ON rl.release_group = rg.id
         LEFT JOIN release_group_primary_type rgpt
                ON rg.type = rgpt.id
         LEFT JOIN release_group_secondary_type_join rgstj
                ON rgstj.release_group = rg.id
         LEFT JOIN release_group_secondary_type rgst
                ON rgstj.secondary_type = rgst.id
              JOIN artist_credit ac
                ON rl.artist_credit = ac.id
              JOIN artist_credit_name acn
                ON acn.artist_credit = ac.id
              JOIN artist a
                ON acn.artist = a.id
          GROUP BY release_mbid, release_name, date, artist_credit_name, release_group_primary_type, release_group_secondary_type
          ORDER BY date, ac.name
                ;