albums_artists
4 rows where artist_id = 7712
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 15098 | 15098 | 14754 14754 | 7712 7712 |
| 17315 | 17315 | 17013 17013 | 7712 7712 |
| 17316 | 17316 | 17014 17014 | 7712 7712 |
| 19581 | 19581 | 19369 19369 | 7712 7712 |
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) );