albums_artists
11 rows where artist_id = 7576
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 14695 | 14695 | 14340 14340 | 7576 7576 |
| 15386 | 15386 | 15043 15043 | 7576 7576 |
| 16134 | 16134 | 15807 15807 | 7576 7576 |
| 16793 | 16793 | 16485 16485 | 7576 7576 |
| 17238 | 17238 | 16935 16935 | 7576 7576 |
| 18222 | 18222 | 17942 17942 | 7576 7576 |
| 18559 | 18559 | 18302 18302 | 7576 7576 |
| 19072 | 19072 | 18847 18847 | 7576 7576 |
| 19328 | 19328 | 19110 19110 | 7576 7576 |
| 23048 | 23048 | 22952 22952 | 7576 7576 |
| 23760 | 23760 | 23651 23651 | 7576 7576 |
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) );