albums_artists
9 rows where artist_id = 9200
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 19176 | 19176 | 18954 18954 | 9200 9200 |
| 20298 | 20298 | 20127 20127 | 9200 9200 |
| 21614 | 21614 | 21500 21500 | 9200 9200 |
| 22074 | 22074 | 21978 21978 | 9200 9200 |
| 22318 | 22318 | 22229 22229 | 9200 9200 |
| 23042 | 23042 | 22946 22946 | 9200 9200 |
| 24011 | 24011 | 23900 23900 | 9200 9200 |
| 24134 | 24134 | 24024 24024 | 9200 9200 |
| 25046 | 25046 | 24939 24939 | 9200 9200 |
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) );