albums_artists
15 rows where artist_id = 232
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 238 | 238 | 228 228 | 232 232 |
| 2948 | 2948 | 2778 2778 | 232 232 |
| 4081 | 4081 | 3882 3882 | 232 232 |
| 4843 | 4843 | 4623 4623 | 232 232 |
| 5375 | 5375 | 5123 5123 | 232 232 |
| 7064 | 7064 | 6767 6767 | 232 232 |
| 8865 | 8865 | 8532 8532 | 232 232 |
| 10983 | 10983 | 10640 10640 | 232 232 |
| 11788 | 11788 | 11447 11447 | 232 232 |
| 12729 | 12729 | 12390 12390 | 232 232 |
| 13840 | 13840 | 13482 13482 | 232 232 |
| 14289 | 14289 | 13931 13931 | 232 232 |
| 15382 | 15382 | 15039 15039 | 232 232 |
| 16448 | 16448 | 16135 16135 | 232 232 |
| 16449 | 16449 | 16136 16136 | 232 232 |
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) );