albums_artists
5 rows where artist_id = 7594
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 14737 | 14737 | 14383 14383 | 7594 7594 |
| 15376 | 15376 | 15033 15033 | 7594 7594 |
| 18887 | 18887 | 18644 18644 | 7594 7594 |
| 21064 | 21064 | 20925 20925 | 7594 7594 |
| 23388 | 23388 | 23285 23285 | 7594 7594 |
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) );