albums_artists
5 rows where artist_id = 5615
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 9731 | 9731 | 9385 9385 | 5615 5615 |
| 12135 | 12135 | 11796 11796 | 5615 5615 |
| 13507 | 13507 | 13156 13156 | 5615 5615 |
| 13915 | 13915 | 13557 13557 | 5615 5615 |
| 15822 | 15822 | 15480 15480 | 5615 5615 |
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) );