albums_artists
8 rows where artist_id = 4906
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 8072 | 8072 | 7759 7759 | 4906 4906 |
| 8885 | 8885 | 8551 8551 | 4906 4906 |
| 11368 | 11368 | 11029 11029 | 4906 4906 |
| 12122 | 12122 | 11783 11783 | 4906 4906 |
| 12534 | 12534 | 12195 12195 | 4906 4906 |
| 13872 | 13872 | 13515 13515 | 4906 4906 |
| 14243 | 14243 | 13883 13883 | 4906 4906 |
| 14244 | 14244 | 13884 13884 | 4906 4906 |
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) );