albums_artists
6 rows where artist_id = 5968
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 10552 | 10552 | 10214 10214 | 5968 5968 |
| 16643 | 16643 | 16332 16332 | 5968 5968 |
| 19874 | 19874 | 19683 19683 | 5968 5968 |
| 21080 | 21080 | 20943 20943 | 5968 5968 |
| 21980 | 21980 | 21880 21880 | 5968 5968 |
| 22926 | 22926 | 22829 22829 | 5968 5968 |
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) );