albums_artists
19 rows where artist_id = 283
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 290 | 290 | 277 277 | 283 283 |
| 4117 | 4117 | 3917 3917 | 283 283 |
| 5748 | 5748 | 5484 5484 | 283 283 |
| 5816 | 5816 | 5549 5549 | 283 283 |
| 8219 | 8219 | 7898 7898 | 283 283 |
| 8221 | 8221 | 7899 7899 | 283 283 |
| 8262 | 8262 | 7943 7943 | 283 283 |
| 9312 | 9312 | 8966 8966 | 283 283 |
| 10918 | 10918 | 10577 10577 | 283 283 |
| 12356 | 12356 | 12020 12020 | 283 283 |
| 13978 | 13978 | 13623 13623 | 283 283 |
| 15281 | 15281 | 14936 14936 | 283 283 |
| 16787 | 16787 | 16479 16479 | 283 283 |
| 17587 | 17587 | 17291 17291 | 283 283 |
| 18655 | 18655 | 18406 18406 | 283 283 |
| 20896 | 20896 | 20746 20746 | 283 283 |
| 23529 | 23529 | 23425 23425 | 283 283 |
| 25471 | 25471 | 25371 25371 | 283 283 |
| 25552 | 25552 | 25453 25453 | 283 283 |
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) );