albums_artists
9 rows where artist_id = 4650
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 7425 | 7425 | 7124 7124 | 4650 4650 |
| 8510 | 8510 | 8178 8178 | 4650 4650 |
| 16799 | 16799 | 16491 16491 | 4650 4650 |
| 19236 | 19236 | 19016 19016 | 4650 4650 |
| 22472 | 22472 | 22376 22376 | 4650 4650 |
| 24459 | 24459 | 24347 24347 | 4650 4650 |
| 24576 | 24576 | 24455 24455 | 4650 4650 |
| 25578 | 25578 | 25480 25480 | 4650 4650 |
| 26052 | 26052 | 25953 25953 | 4650 4650 |
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) );