I’m using the data dumps in Postgres to query for all vinyl associated with an artist. The medium format table contains a number of formats for vinyl but no mention of 2×Vinyl that is referred in the website when you’re browsing.
I have queried a number of albums where the medium is 2xVinyl and the query doesn’t even reference it as vinyl at all. With Albums that a just have one vinyl disc are referenced correctly however.
SELECT DISTINCT ON (release.id)
INNER JOIN (
id AS medium_id,
medium) medium ON medium.medium_id = release.id
release.name = 'A Moon Shaped Pool'```
CREATE TABLE medium ( -- replicate (verbose)
release INTEGER NOT NULL, -- references release.id
position INTEGER NOT NULL,
format INTEGER, -- references medium_format.id
name VARCHAR NOT NULL DEFAULT '',
edits_pending INTEGER NOT NULL DEFAULT 0 CHECK (edits_pending >= 0),
last_updated TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
track_count INTEGER NOT NULL DEFAULT 0