albums_artists
9 rows where artist_id = 3762
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 5476 | 5476 | 5220 5220 | 3762 3762 |
| 13667 | 13667 | 13316 13316 | 3762 3762 |
| 16210 | 16210 | 15889 15889 | 3762 3762 |
| 17476 | 17476 | 17182 17182 | 3762 3762 |
| 20428 | 20428 | 20262 20262 | 3762 3762 |
| 21906 | 21906 | 21802 21802 | 3762 3762 |
| 22159 | 22159 | 22065 22065 | 3762 3762 |
| 23036 | 23036 | 22940 22940 | 3762 3762 |
| 26240 | 26240 | 26138 26138 | 3762 3762 |
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) );