albums_artists
12 rows where artist_id = 720
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 749 | 749 | 712 712 | 720 720 |
| 1212 | 1212 | 1142 1142 | 720 720 |
| 3621 | 3621 | 3424 3424 | 720 720 |
| 12658 | 12658 | 12318 12318 | 720 720 |
| 17556 | 17556 | 17261 17261 | 720 720 |
| 19591 | 19591 | 19380 19380 | 720 720 |
| 19722 | 19722 | 19526 19526 | 720 720 |
| 22338 | 22338 | 22248 22248 | 720 720 |
| 23981 | 23981 | 23869 23869 | 720 720 |
| 25130 | 25130 | 25025 25025 | 720 720 |
| 25399 | 25399 | 25303 25303 | 720 720 |
| 26336 | 26336 | 26230 26230 | 720 720 |
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) );