# Pastebin LcZccCaA
                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
                         , array_agg(t.name) AS tag_name
                         , COUNT(*) OVER () AS total_count
                      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
                      JOIN release_tag rt
                        ON rt.release = rl.id
                      JOIN tag t
                        ON rt.tag = t.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_date
                         , release_mbid
                         , release_id
                         , release_name
                         , release_date
                         , artist_credit_name
                         , release_group_primary_type
                         , release_group_secondary_type
                  ORDER BY rg.id
                         , release_date
                ) SELECT *,
                         total_count AS total_count
                    FROM releases
                ORDER BY {sort_order_str}
                LIMIT %s OFFSET %s;