albums_artists
10 rows where artist_id = 272
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 279 | 279 | 267 267 | 272 272 |
| 1185 | 1185 | 1116 1116 | 272 272 |
| 2322 | 2322 | 2178 2178 | 272 272 |
| 3700 | 3700 | 3500 3500 | 272 272 |
| 5988 | 5988 | 5717 5717 | 272 272 |
| 8050 | 8050 | 7738 7738 | 272 272 |
| 9423 | 9423 | 9075 9075 | 272 272 |
| 9677 | 9677 | 9329 9329 | 272 272 |
| 11161 | 11161 | 10822 10822 | 272 272 |
| 15669 | 15669 | 15331 15331 | 272 272 |
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) );