albums_artists
10 rows where artist_id = 1658
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 1876 | 1876 | 1770 1770 | 1658 1658 |
| 2943 | 2943 | 2773 2773 | 1658 1658 |
| 4211 | 4211 | 4009 4009 | 1658 1658 |
| 10254 | 10254 | 9915 9915 | 1658 1658 |
| 12745 | 12745 | 12406 12406 | 1658 1658 |
| 15252 | 15252 | 14907 14907 | 1658 1658 |
| 15692 | 15692 | 15355 15355 | 1658 1658 |
| 16609 | 16609 | 16298 16298 | 1658 1658 |
| 17717 | 17717 | 17421 17421 | 1658 1658 |
| 19713 | 19713 | 19516 19516 | 1658 1658 |
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) );