albums_artists
9 rows where artist_id = 618
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 638 | 638 | 613 613 | 618 618 |
| 1519 | 1519 | 1433 1433 | 618 618 |
| 2631 | 2631 | 2476 2476 | 618 618 |
| 3759 | 3759 | 3560 3560 | 618 618 |
| 6215 | 6215 | 5935 5935 | 618 618 |
| 7828 | 7828 | 7516 7516 | 618 618 |
| 11071 | 11071 | 10731 10731 | 618 618 |
| 12812 | 12812 | 12470 12470 | 618 618 |
| 26709 | 26709 | 26581 26581 | 618 618 |
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) );