# Does 2×12" Vinyl have a medium format associated with it?
**URL:** https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718
**Category:** Development
**Tags:** database, musicbrainz
**Created:** [July 20, 2022, 8:00pm UTC](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718 "2022-07-20T20:00:55Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@tangibletracks](https://community.metabrainz.org/u/tangibletracks)
#### Post date: [July 20, 2022, 8:00pm UTC](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718/1 "2022-07-20T20:00:55Z")
I downloaded the data dumps and imported into Postgres, and what I have noticed is I can query by media id (31 for vinyl) just fine, but it skips over releases that are stated as 2×12" on the website. Does 2×12" Vinyl have a medium format associated with it? I don’t see one when I view the medium\_format table. Hope that makes sense!
Thank you.
---
### Author:  [@Zas](https://community.metabrainz.org/u/Zas)
#### Post date: [July 22, 2022, 10:01am UTC](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718/2 "2022-07-22T10:01:39Z")
Such releases have 2 mediums, both of them being 12’’ vinyl, one at position 1 and the other at position 2.
See [Medium - MusicBrainz](https://musicbrainz.org/doc/Medium) and the schema at [MusicBrainz Database / Schema - MusicBrainz](https://musicbrainz.org/doc/MusicBrainz_Database/Schema)
---
### Author:  [@tangibletracks](https://community.metabrainz.org/u/tangibletracks)
#### Post date: [July 22, 2022, 8:19pm UTC](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718/3 "2022-07-22T20:19:12Z")
Thank you this is helpful.
I think what my issue is my confusion with release groups and releases. I want to get all major albums that are on 12 inch vinyl only by artist. My query is clearly off.
---
### Author:  [@iolomorganwg](https://community.metabrainz.org/u/iolomorganwg)
#### Post date: [July 23, 2022, 1:01pm UTC](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718/4 "2022-07-23T13:01:54Z")
You can do this with the advanced query syntax.
When you make a search, at the bottom of the page which it opens, there is a checkbox, “Indexed search with [advanced query syntax](https://musicbrainz.org/doc/Indexed_Search_Syntax)”.
Here’s an example:
`arid:5c95f00a-439e-47e4-8c7b-89d853d860bf AND format:"12\" Vinyl" AND primarytype:Album AND -secondarytype:compilation`
This matches the following artist: [Don Rendell Ian Carr Quintet - MusicBrainz](https://musicbrainz.org/artist/5c95f00a-439e-47e4-8c7b-89d853d860bf), only searches for 12" Vinyl as the format, the primary type is album, and the secondarytype is not compilation. (Note the dash before -secondarytype, to inidicate that we certainly don’t want to match that field.)
This returns five LPs by the Don Rendell Ian Carr Quintet, and excludes the reissue compilation box set: [Search results - MusicBrainz](https://musicbrainz.org/search?query=arid%3A5c95f00a-439e-47e4-8c7b-89d853d860bf+AND+format%3A%2212%5C%22+Vinyl%22+AND+primarytype%3AAlbum+AND+-secondarytype%3Acompilation&type=release&limit=25&method=advanced)
On the latter point, I supposed that that’s what you meant by ‘major album’, any album which is not a compilation. You can exclude live albums by doing the same thing -secondarytype:live.
If I wanted to match all artists with that name (better for much more obscure artists like this one), do something like artist:“Don Rendell”. This produces additional albums as it matches the individual and other groups:
> **[Search results - MusicBrainz](https://musicbrainz.org/search?query=artist%3A%22Don+Rendell%22+AND+format%3A%2212%5C%22+Vinyl%22+AND+primarytype%3AAlbum+AND+-secondarytype%3Acompilation&type=release&limit=25&method=advanced)**
Hope that is helpful. The advanced query syntax is really powerful and effective. (If somewhat frustrating if one has never used it before).