albums_artists
6 rows where artist_id = 203
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 208 | 208 | 201 201 | 203 203 |
| 1340 | 1340 | 1261 1261 | 203 203 |
| 3034 | 3034 | 2859 2859 | 203 203 |
| 3886 | 3886 | 3681 3681 | 203 203 |
| 5163 | 5163 | 4920 4920 | 203 203 |
| 7230 | 7230 | 6932 6932 | 203 203 |
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) );