albums_artists
9 rows where artist_id = 5995
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 10606 | 10606 | 10269 10269 | 5995 5995 |
| 12118 | 12118 | 11779 11779 | 5995 5995 |
| 14939 | 14939 | 14590 14590 | 5995 5995 |
| 15944 | 15944 | 15607 15607 | 5995 5995 |
| 19063 | 19063 | 18837 18837 | 5995 5995 |
| 19797 | 19797 | 19602 19602 | 5995 5995 |
| 19798 | 19798 | 19603 19603 | 5995 5995 |
| 20797 | 20797 | 20640 20640 | 5995 5995 |
| 22168 | 22168 | 22074 22074 | 5995 5995 |
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) );