albums_artists
8 rows where artist_id = 7960
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 15860 | 15860 | 15516 15516 | 7960 7960 |
| 18736 | 18736 | 18493 18493 | 7960 7960 |
| 19221 | 19221 | 19001 19001 | 7960 7960 |
| 19965 | 19965 | 19777 19777 | 7960 7960 |
| 21361 | 21361 | 21238 21238 | 7960 7960 |
| 22317 | 22317 | 22228 22228 | 7960 7960 |
| 22956 | 22956 | 22860 22860 | 7960 7960 |
| 24086 | 24086 | 23976 23976 | 7960 7960 |
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) );