albums_artists
5 rows where artist_id = 6365
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 11422 | 11422 | 11083 11083 | 6365 6365 |
| 19775 | 19775 | 19579 19579 | 6365 6365 |
| 22936 | 22936 | 22839 22839 | 6365 6365 |
| 24127 | 24127 | 24017 24017 | 6365 6365 |
| 24675 | 24675 | 24552 24552 | 6365 6365 |
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) );