albums_artists
7 rows where artist_id = 4735
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 7655 | 7655 | 7349 7349 | 4735 4735 |
| 12275 | 12275 | 11938 11938 | 4735 4735 |
| 15639 | 15639 | 15300 15300 | 4735 4735 |
| 18140 | 18140 | 17856 17856 | 4735 4735 |
| 20393 | 20393 | 20226 20226 | 4735 4735 |
| 21536 | 21536 | 21416 21416 | 4735 4735 |
| 25851 | 25851 | 25752 25752 | 4735 4735 |
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) );