albums_artists
5 rows where artist_id = 1614
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 1819 | 1819 | 1718 1718 | 1614 1614 |
| 6452 | 6452 | 6160 6160 | 1614 1614 |
| 17293 | 17293 | 16990 16990 | 1614 1614 |
| 20687 | 20687 | 20525 20525 | 1614 1614 |
| 26844 | 26844 | 26706 26706 | 1614 1614 |
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) );