albums_artists
5 rows where artist_id = 6440
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 11622 | 11622 | 11285 11285 | 6440 6440 |
| 11623 | 11623 | 11286 11286 | 6440 6440 |
| 11624 | 11624 | 11287 11287 | 6440 6440 |
| 12853 | 12853 | 12510 12510 | 6440 6440 |
| 22417 | 22417 | 22322 22322 | 6440 6440 |
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) );