albums_artists
8 rows where artist_id = 4736
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 7657 | 7657 | 7351 7351 | 4736 4736 |
| 10329 | 10329 | 9986 9986 | 4736 4736 |
| 10845 | 10845 | 10508 10508 | 4736 4736 |
| 10846 | 10846 | 10509 10509 | 4736 4736 |
| 12184 | 12184 | 11847 11847 | 4736 4736 |
| 14113 | 14113 | 13758 13758 | 4736 4736 |
| 14963 | 14963 | 14613 14613 | 4736 4736 |
| 26656 | 26656 | 26536 26536 | 4736 4736 |
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) );