albums_artists
9 rows where artist_id = 650
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 672 | 672 | 645 645 | 650 650 |
| 4209 | 4209 | 4007 4007 | 650 650 |
| 4613 | 4613 | 4395 4395 | 650 650 |
| 6193 | 6193 | 5913 5913 | 650 650 |
| 8612 | 8612 | 8277 8277 | 650 650 |
| 9623 | 9623 | 9276 9276 | 650 650 |
| 11825 | 11825 | 11484 11484 | 650 650 |
| 15235 | 15235 | 14890 14890 | 650 650 |
| 17480 | 17480 | 17186 17186 | 650 650 |
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) );