albums_artists
5 rows where artist_id = 2437
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 3038 | 3038 | 2863 2863 | 2437 2437 |
| 11540 | 11540 | 11202 11202 | 2437 2437 |
| 14584 | 14584 | 14230 14230 | 2437 2437 |
| 16290 | 16290 | 15974 15974 | 2437 2437 |
| 17268 | 17268 | 16965 16965 | 2437 2437 |
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) );