albums_artists
5 rows where artist_id = 8351
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 16884 | 16884 | 16574 16574 | 8351 8351 |
| 21232 | 21232 | 21107 21107 | 8351 8351 |
| 23521 | 23521 | 23416 23416 | 8351 8351 |
| 25604 | 25604 | 25506 25506 | 8351 8351 |
| 26174 | 26174 | 26072 26072 | 8351 8351 |
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) );