albums_artists
8 rows where artist_id = 560
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 577 | 577 | 553 553 | 560 560 |
| 3694 | 3694 | 3495 3495 | 560 560 |
| 4494 | 4494 | 4277 4277 | 560 560 |
| 9188 | 9188 | 8845 8845 | 560 560 |
| 12317 | 12317 | 11980 11980 | 560 560 |
| 13047 | 13047 | 12709 12709 | 560 560 |
| 15642 | 15642 | 15304 15304 | 560 560 |
| 18211 | 18211 | 17929 17929 | 560 560 |
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) );