albums_artists
6 rows where artist_id = 8262
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 16629 | 16629 | 16318 16318 | 8262 8262 |
| 19000 | 19000 | 18768 18768 | 8262 8262 |
| 20068 | 20068 | 19886 19886 | 8262 8262 |
| 20956 | 20956 | 20810 20810 | 8262 8262 |
| 21813 | 21813 | 21708 21708 | 8262 8262 |
| 22083 | 22083 | 21987 21987 | 8262 8262 |
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) );