Skip to content

Instantly share code, notes, and snippets.

@stevenleeg
Created November 21, 2012 22:20
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 stevenleeg/4128236 to your computer and use it in GitHub Desktop.
Save stevenleeg/4128236 to your computer and use it in GitHub Desktop.
[Musicbrainz] Get meta data from release mbid
SELECT
musicbrainz.release.gid AS release_mbid,
musicbrainz.release_meta.amazon_asin AS asin,
musicbrainz.release_meta.cover_art_presence AS art
FROM
musicbrainz.release_group
INNER JOIN musicbrainz.release
ON musicbrainz.release.release_group = musicbrainz.release_group.id
INNER JOIN musicbrainz.release_meta
ON musicbrainz.release_meta.id = musicbrainz.release.id
WHERE
musicbrainz.release_group.gid = :mbid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment