albums_artists
15 rows where artist_id = 2981
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 3952 | 3952 | 3750 3750 | 2981 2981 |
| 4742 | 4742 | 4526 4526 | 2981 2981 |
| 7574 | 7574 | 7268 7268 | 2981 2981 |
| 7576 | 7576 | 7269 7269 | 2981 2981 |
| 8497 | 8497 | 8166 8166 | 2981 2981 |
| 9109 | 9109 | 8769 8769 | 2981 2981 |
| 10045 | 10045 | 9701 9701 | 2981 2981 |
| 19180 | 19180 | 18959 18959 | 2981 2981 |
| 20966 | 20966 | 20820 20820 | 2981 2981 |
| 21459 | 21459 | 21339 21339 | 2981 2981 |
| 23645 | 23645 | 23541 23541 | 2981 2981 |
| 23646 | 23646 | 23542 23542 | 2981 2981 |
| 23983 | 23983 | 23871 23871 | 2981 2981 |
| 24292 | 24292 | 24182 24182 | 2981 2981 |
| 24636 | 24636 | 24514 24514 | 2981 2981 |
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) );