albums_artists
8 rows where artist_id = 7015
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 13102 | 13102 | 12764 12764 | 7015 7015 |
| 18960 | 18960 | 18725 18725 | 7015 7015 |
| 21512 | 21512 | 21391 21391 | 7015 7015 |
| 22068 | 22068 | 21971 21971 | 7015 7015 |
| 23071 | 23071 | 22972 22972 | 7015 7015 |
| 23072 | 23072 | 22973 22973 | 7015 7015 |
| 24363 | 24363 | 24249 24249 | 7015 7015 |
| 25441 | 25441 | 25341 25341 | 7015 7015 |
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) );