albums_artists
20 rows where artist_id = 246
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 252 | 252 | 241 241 | 246 246 |
| 3255 | 3255 | 3072 3072 | 246 246 |
| 6164 | 6164 | 5885 5885 | 246 246 |
| 7262 | 7262 | 6965 6965 | 246 246 |
| 8913 | 8913 | 8577 8577 | 246 246 |
| 9959 | 9959 | 9614 9614 | 246 246 |
| 12485 | 12485 | 12147 12147 | 246 246 |
| 13956 | 13956 | 13599 13599 | 246 246 |
| 15483 | 15483 | 15141 15141 | 246 246 |
| 16649 | 16649 | 16339 16339 | 246 246 |
| 19306 | 19306 | 19088 19088 | 246 246 |
| 20217 | 20217 | 20041 20041 | 246 246 |
| 21354 | 21354 | 21231 21231 | 246 246 |
| 22552 | 22552 | 22458 22458 | 246 246 |
| 22817 | 22817 | 22726 22726 | 246 246 |
| 22818 | 22818 | 22727 22727 | 246 246 |
| 22819 | 22819 | 22728 22728 | 246 246 |
| 22820 | 22820 | 22729 22729 | 246 246 |
| 25631 | 25631 | 25533 25533 | 246 246 |
| 25945 | 25945 | 25846 25846 | 246 246 |
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) );