albums_artists
16 rows where artist_id = 239
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 245 | 245 | 235 235 | 239 239 |
| 1811 | 1811 | 1711 1711 | 239 239 |
| 4430 | 4430 | 4217 4217 | 239 239 |
| 5220 | 5220 | 4975 4975 | 239 239 |
| 7596 | 7596 | 7289 7289 | 239 239 |
| 11137 | 11137 | 10799 10799 | 239 239 |
| 13543 | 13543 | 13192 13192 | 239 239 |
| 17577 | 17577 | 17281 17281 | 239 239 |
| 20118 | 20118 | 19941 19941 | 239 239 |
| 20565 | 20565 | 20404 20404 | 239 239 |
| 20566 | 20566 | 20405 20405 | 239 239 |
| 23194 | 23194 | 23091 23091 | 239 239 |
| 24586 | 24586 | 24464 24464 | 239 239 |
| 25197 | 25197 | 25092 25092 | 239 239 |
| 25592 | 25592 | 25494 25494 | 239 239 |
| 25897 | 25897 | 25799 25799 | 239 239 |
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) );