albums_artists
6 rows where artist_id = 6721
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 12278 | 12278 | 11941 11941 | 6721 6721 |
| 12762 | 12762 | 12420 12420 | 6721 6721 |
| 13130 | 13130 | 12791 12791 | 6721 6721 |
| 13617 | 13617 | 13267 13267 | 6721 6721 |
| 14136 | 14136 | 13780 13780 | 6721 6721 |
| 15108 | 15108 | 14763 14763 | 6721 6721 |
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) );