I’m trying to generate a list of all vinyl albums for all artists.
I can get this for a specific artist as follows:
select a.id as artistid, a.name, r.id, r.name as album_name, r.packaging from artist_credit_name join artist a ON artist_credit_name.artist = a.id join artist_credit ac ON artist_credit_name.artist_credit = ac.id join release r ON r.artist_credit = ac.id where r.artist_credit = 1352 /* 1352 is AC/DC */ and r.packaging = 12
I am using packaging=12 because I think this means vinyl, but it may be possible for “Gatefold Cover” to also apply to CDs.
Is there a way to find any vinyl-only albums for a given artist (or all artists)? Ultimately, I’m after all vinyl albums in the db.