albums_artists
8 rows where artist_id = 7304
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 13959 | 13959 | 13602 13602 | 7304 7304 |
| 15487 | 15487 | 15144 15144 | 7304 7304 |
| 17567 | 17567 | 17271 17271 | 7304 7304 |
| 22006 | 22006 | 21906 21906 | 7304 7304 |
| 24373 | 24373 | 24260 24260 | 7304 7304 |
| 24976 | 24976 | 24868 24868 | 7304 7304 |
| 25790 | 25790 | 25691 25691 | 7304 7304 |
| 26160 | 26160 | 26058 26058 | 7304 7304 |
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) );