albums_artists
6 rows where artist_id = 262
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 269 | 269 | 257 257 | 262 262 |
| 5932 | 5932 | 5664 5664 | 262 262 |
| 9702 | 9702 | 9355 9355 | 262 262 |
| 12623 | 12623 | 12285 12285 | 262 262 |
| 13893 | 13893 | 13535 13535 | 262 262 |
| 14900 | 14900 | 14553 14553 | 262 262 |
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) );