albums_artists
5 rows where artist_id = 7419
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 14253 | 14253 | 13895 13895 | 7419 7419 |
| 17034 | 17034 | 16731 16731 | 7419 7419 |
| 20260 | 20260 | 20085 20085 | 7419 7419 |
| 22827 | 22827 | 22736 22736 | 7419 7419 |
| 24971 | 24971 | 24863 24863 | 7419 7419 |
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) );