albums_artists
8 rows where artist_id = 8259
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 16624 | 16624 | 16313 16313 | 8259 8259 |
| 17746 | 17746 | 17451 17451 | 8259 8259 |
| 18784 | 18784 | 18542 18542 | 8259 8259 |
| 20552 | 20552 | 20391 20391 | 8259 8259 |
| 21134 | 21134 | 21002 21002 | 8259 8259 |
| 22151 | 22151 | 22056 22056 | 8259 8259 |
| 22720 | 22720 | 22628 22628 | 8259 8259 |
| 23567 | 23567 | 23463 23463 | 8259 8259 |
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) );