albums_artists
7 rows where artist_id = 940
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 984 | 984 | 928 928 | 940 940 |
| 985 | 985 | 929 929 | 940 940 |
| 986 | 986 | 930 930 | 940 940 |
| 987 | 987 | 931 931 | 940 940 |
| 988 | 988 | 932 932 | 940 940 |
| 3976 | 3976 | 3771 3771 | 940 940 |
| 7877 | 7877 | 7561 7561 | 940 940 |
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) );