albums_artists
4 rows where artist_id = 9944
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 21449 | 21449 | 21329 21329 | 9944 9944 |
| 21999 | 21999 | 21899 21899 | 9944 9944 |
| 24447 | 24447 | 24336 24336 | 9944 9944 |
| 25264 | 25264 | 25162 25162 | 9944 9944 |
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) );