albums_artists
7 rows where artist_id = 4762
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 7722 | 7722 | 7415 7415 | 4762 4762 |
| 7723 | 7723 | 7416 7416 | 4762 4762 |
| 9509 | 9509 | 9163 9163 | 4762 4762 |
| 17998 | 17998 | 17708 17708 | 4762 4762 |
| 19564 | 19564 | 19352 19352 | 4762 4762 |
| 20916 | 20916 | 20767 20767 | 4762 4762 |
| 22856 | 22856 | 22762 22762 | 4762 4762 |
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) );