albums_artists
8 rows where artist_id = 4764
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 7728 | 7728 | 7421 7421 | 4764 4764 |
| 10387 | 10387 | 10046 10046 | 4764 4764 |
| 15271 | 15271 | 14926 14926 | 4764 4764 |
| 19402 | 19402 | 19186 19186 | 4764 4764 |
| 23005 | 23005 | 22910 22910 | 4764 4764 |
| 25902 | 25902 | 25804 25804 | 4764 4764 |
| 26018 | 26018 | 25919 25919 | 4764 4764 |
| 27183 | 27183 | 27021 27021 | 4764 4764 |
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) );