albums_artists
5 rows where artist_id = 8589
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 17526 | 17526 | 17231 17231 | 8589 8589 |
| 21913 | 21913 | 21809 21809 | 8589 8589 |
| 22537 | 22537 | 22443 22443 | 8589 8589 |
| 24350 | 24350 | 24236 24236 | 8589 8589 |
| 24889 | 24889 | 24779 24779 | 8589 8589 |
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) );