albums_artists
6 rows where artist_id = 2260
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 2737 | 2737 | 2574 2574 | 2260 2260 |
| 2738 | 2738 | 2575 2575 | 2260 2260 |
| 2739 | 2739 | 2576 2576 | 2260 2260 |
| 19539 | 19539 | 19326 19326 | 2260 2260 |
| 22484 | 22484 | 22388 22388 | 2260 2260 |
| 22650 | 22650 | 22557 22557 | 2260 2260 |
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) );