albums_artists
8 rows where artist_id = 8762
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 17918 | 17918 | 17625 17625 | 8762 8762 |
| 17919 | 17919 | 17626 17626 | 8762 8762 |
| 17920 | 17920 | 17627 17627 | 8762 8762 |
| 17921 | 17921 | 17628 17628 | 8762 8762 |
| 19312 | 19312 | 19094 19094 | 8762 8762 |
| 19945 | 19945 | 19757 19757 | 8762 8762 |
| 22402 | 22402 | 22308 22308 | 8762 8762 |
| 26092 | 26092 | 25988 25988 | 8762 8762 |
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) );