albums_artists
9 rows where artist_id = 6064
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 10752 | 10752 | 10418 10418 | 6064 6064 |
| 17111 | 17111 | 16812 16812 | 6064 6064 |
| 17874 | 17874 | 17581 17581 | 6064 6064 |
| 19005 | 19005 | 18773 18773 | 6064 6064 |
| 22911 | 22911 | 22815 22815 | 6064 6064 |
| 23012 | 23012 | 22917 22917 | 6064 6064 |
| 25095 | 25095 | 24992 24992 | 6064 6064 |
| 25238 | 25238 | 25134 25134 | 6064 6064 |
| 26000 | 26000 | 25901 25901 | 6064 6064 |
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) );