albums_artists
7 rows where artist_id = 350
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 358 | 358 | 341 341 | 350 350 |
| 575 | 575 | 551 551 | 350 350 |
| 7647 | 7647 | 7341 7341 | 350 350 |
| 13174 | 13174 | 12834 12834 | 350 350 |
| 16727 | 16727 | 16418 16418 | 350 350 |
| 20356 | 20356 | 20188 20188 | 350 350 |
| 23118 | 23118 | 23017 23017 | 350 350 |
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) );