# Pastebin u5pYjDKP
        WITH releases AS (
            SELECT DISTINCT ON (rg.id)
                   rl.id AS release_id
                 , rl.gid AS release_mbid
                 , rg.gid AS release_group_mbid
                 , rl.name AS release_name
                 , make_date(rgm.first_release_date_year,
                              rgm.first_release_date_month,
                              rgm.first_release_date_day) AS release_date
                 , ac.name AS artist_credit_name
                 , array_agg(distinct a.gid) AS artist_mbids
                 , rgpt.name AS release_group_primary_type
                 , rgst.name AS release_group_secondary_type
              FROM release rl
              JOIN release_group rg
                ON rl.release_group = rg.id
              JOIN release_group_meta rgm
                ON rgm.id = 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
             WHERE make_date(rgm.first_release_date_year,
                             rgm.first_release_date_month,
                             rgm.first_release_date_day) >= %s
               AND make_date(rgm.first_release_date_year,
                             rgm.first_release_date_month,
                             rgm.first_release_date_day) <= %s
          GROUP BY rg.id
                 , release_mbid
                 , release_group_mbid
                 , release_id
                 , release_name
                 , release_date
                 , artist_credit_name
                 , release_group_primary_type
                 , release_group_secondary_type
        ) SELECT rl.*
                , array_agg(t.name) AS tags
                , count(*) AS total_count
            FROM releases rl
       LEFT JOIN release_tag rt
              ON rt.release = rl.release_id
       LEFT JOIN tag t
              ON rt.tag = t.id
        GROUP BY release_id
               , release_group_mbid
               , release_mbid
               , release_name
               , release_date
               , artist_credit_name
               , release_group_primary_type
               , release_group_secondary_type
               , artist_mbids
        ORDER BY release_date
               , artist_credit_name
               , release_name