albums_artists
6 rows where artist_id = 7006
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 13080 | 13080 | 12743 12743 | 7006 7006 |
| 18039 | 18039 | 17749 17749 | 7006 7006 |
| 19152 | 19152 | 18930 18930 | 7006 7006 |
| 23716 | 23716 | 23607 23607 | 7006 7006 |
| 24669 | 24669 | 24546 24546 | 7006 7006 |
| 26252 | 26252 | 26150 26150 | 7006 7006 |
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) );