Skip to content

Instantly share code, notes, and snippets.

@mayhem

mayhem/gist:3a6fc996fa5756944dceff13e5ae1da5

Created July 25, 2020 14:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mayhem/3a6fc996fa5756944dceff13e5ae1da5 to your computer and use it in GitHub Desktop.
Save mayhem/3a6fc996fa5756944dceff13e5ae1da5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
musicbrainz_db=# SELECT ac.id AS artist_credit_id,
musicbrainz_db-# ar.name AS area_name,
musicbrainz_db-# code AS area_code,
musicbrainz_db-# array_agg(a.gid) AS artist_credit_mbids
musicbrainz_db-# FROM artist_credit ac
musicbrainz_db-# JOIN artist_credit_name acn
musicbrainz_db-# ON ac.id = acn.artist_credit
musicbrainz_db-# JOIN artist a
musicbrainz_db-# ON acn.artist = a.id
musicbrainz_db-# JOIN area ar
musicbrainz_db-# ON a.area = ar.id
musicbrainz_db-# JOIN iso_3166_1 i
musicbrainz_db-# ON i.area = a.area
musicbrainz_db-# WHERE ac.id = 810828
musicbrainz_db-# GROUP BY ac.id, ar.name, area_code;
artist_credit_id | area_name | area_code | artist_credit_mbids
------------------+----------------+-----------+-----------------------------------------------------------------------------
810828 | United Kingdom | GB | {0383dadf-2a4e-4d10-a46a-e9e041da8eb3,5441c29d-3602-4898-b1a1-b77fa23b8e50}
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment