albums_artists
19 rows where artist_id = 857
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 896 | 896 | 848 848 | 857 857 |
| 3390 | 3390 | 3199 3199 | 857 857 |
| 6306 | 6306 | 6020 6020 | 857 857 |
| 9184 | 9184 | 8841 8841 | 857 857 |
| 11296 | 11296 | 10960 10960 | 857 857 |
| 14415 | 14415 | 14057 14057 | 857 857 |
| 14867 | 14867 | 14519 14519 | 857 857 |
| 15102 | 15102 | 14758 14758 | 857 857 |
| 15761 | 15761 | 15424 15424 | 857 857 |
| 15762 | 15762 | 15425 15425 | 857 857 |
| 15763 | 15763 | 15426 15426 | 857 857 |
| 16560 | 16560 | 16248 16248 | 857 857 |
| 18273 | 18273 | 17994 17994 | 857 857 |
| 19875 | 19875 | 19685 19685 | 857 857 |
| 20772 | 20772 | 20614 20614 | 857 857 |
| 22092 | 22092 | 21995 21995 | 857 857 |
| 23105 | 23105 | 23004 23004 | 857 857 |
| 24566 | 24566 | 24446 24446 | 857 857 |
| 25976 | 25976 | 25877 25877 | 857 857 |
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) );