albums_artists
5 rows where artist_id = 2357
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 2889 | 2889 | 2720 2720 | 2357 2357 |
| 5115 | 5115 | 4872 4872 | 2357 2357 |
| 7206 | 7206 | 6908 6908 | 2357 2357 |
| 8479 | 8479 | 8150 8150 | 2357 2357 |
| 26929 | 26929 | 26785 26785 | 2357 2357 |
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) );