albums_artists
5 rows where artist_id = 5846
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 10280 | 10280 | 9940 9940 | 5846 5846 |
| 11859 | 11859 | 11518 11518 | 5846 5846 |
| 25858 | 25858 | 25760 25760 | 5846 5846 |
| 26299 | 26299 | 26196 26196 | 5846 5846 |
| 26306 | 26306 | 26204 26204 | 5846 5846 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE albums_artists ( album_id integer NOT NULL, artist_id integer NOT NULL, FOREIGN KEY(artist_id) REFERENCES artists(id), FOREIGN KEY(album_id) REFERENCES albums(id), UNIQUE(album_id, artist_id) );