albums_artists
7 rows where artist_id = 2159
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 2592 | 2592 | 2440 2440 | 2159 2159 |
| 15809 | 15809 | 15467 15467 | 2159 2159 |
| 16981 | 16981 | 16673 16673 | 2159 2159 |
| 21982 | 21982 | 21882 21882 | 2159 2159 |
| 23241 | 23241 | 23138 23138 | 2159 2159 |
| 24935 | 24935 | 24826 24826 | 2159 2159 |
| 25816 | 25816 | 25717 25717 | 2159 2159 |
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) );