albums_artists
6 rows where artist_id = 6392
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 11497 | 11497 | 11160 11160 | 6392 6392 |
| 15450 | 15450 | 15108 15108 | 6392 6392 |
| 16832 | 16832 | 16523 16523 | 6392 6392 |
| 17324 | 17324 | 17022 17022 | 6392 6392 |
| 19529 | 19529 | 19316 19316 | 6392 6392 |
| 20252 | 20252 | 20077 20077 | 6392 6392 |
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) );