albums_artists
13 rows where artist_id = 2450
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 3055 | 3055 | 2880 2880 | 2450 2450 |
| 3555 | 3555 | 3358 3358 | 2450 2450 |
| 6316 | 6316 | 6030 6030 | 2450 2450 |
| 11042 | 11042 | 10701 10701 | 2450 2450 |
| 16946 | 16946 | 16638 16638 | 2450 2450 |
| 17912 | 17912 | 17619 17619 | 2450 2450 |
| 18467 | 18467 | 18199 18199 | 2450 2450 |
| 19510 | 19510 | 19297 19297 | 2450 2450 |
| 19995 | 19995 | 19810 19810 | 2450 2450 |
| 20977 | 20977 | 20831 20831 | 2450 2450 |
| 21882 | 21882 | 21778 21778 | 2450 2450 |
| 24667 | 24667 | 24544 24544 | 2450 2450 |
| 26077 | 26077 | 25974 25974 | 2450 2450 |
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) );