albums_artists
7 rows where artist_id = 4438
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 6953 | 6953 | 6655 6655 | 4438 4438 |
| 13996 | 13996 | 13641 13641 | 4438 4438 |
| 17385 | 17385 | 17088 17088 | 4438 4438 |
| 19337 | 19337 | 19120 19120 | 4438 4438 |
| 20528 | 20528 | 20366 20366 | 4438 4438 |
| 22719 | 22719 | 22627 22627 | 4438 4438 |
| 26705 | 26705 | 26577 26577 | 4438 4438 |
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) );