albums_artists
15 rows where artist_id = 290
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 297 | 297 | 284 284 | 290 290 |
| 6560 | 6560 | 6271 6271 | 290 290 |
| 8181 | 8181 | 7862 7862 | 290 290 |
| 10204 | 10204 | 9865 9865 | 290 290 |
| 12026 | 12026 | 11686 11686 | 290 290 |
| 13128 | 13128 | 12789 12789 | 290 290 |
| 15341 | 15341 | 14998 14998 | 290 290 |
| 15588 | 15588 | 15249 15249 | 290 290 |
| 16371 | 16371 | 16057 16057 | 290 290 |
| 17897 | 17897 | 17602 17602 | 290 290 |
| 19764 | 19764 | 19568 19568 | 290 290 |
| 20348 | 20348 | 20180 20180 | 290 290 |
| 21431 | 21431 | 21309 21309 | 290 290 |
| 22353 | 22353 | 22262 22262 | 290 290 |
| 24676 | 24676 | 24553 24553 | 290 290 |
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) );