albums_artists
8 rows where artist_id = 97
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 102 | 102 | 99 99 | 97 97 |
| 5048 | 5048 | 4809 4809 | 97 97 |
| 6458 | 6458 | 6166 6166 | 97 97 |
| 11935 | 11935 | 11592 11592 | 97 97 |
| 14303 | 14303 | 13945 13945 | 97 97 |
| 15426 | 15426 | 15084 15084 | 97 97 |
| 16188 | 16188 | 15866 15866 | 97 97 |
| 16189 | 16189 | 15867 15867 | 97 97 |
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) );