albums_artists
18 rows where artist_id = 176
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 181 | 181 | 175 175 | 176 176 |
| 1154 | 1154 | 1086 1086 | 176 176 |
| 1797 | 1797 | 1697 1697 | 176 176 |
| 6763 | 6763 | 6469 6469 | 176 176 |
| 13108 | 13108 | 12770 12770 | 176 176 |
| 13737 | 13737 | 13382 13382 | 176 176 |
| 18714 | 18714 | 18470 18470 | 176 176 |
| 21501 | 21501 | 21380 21380 | 176 176 |
| 21502 | 21502 | 21381 21381 | 176 176 |
| 21503 | 21503 | 21382 21382 | 176 176 |
| 21504 | 21504 | 21383 21383 | 176 176 |
| 22286 | 22286 | 22196 22196 | 176 176 |
| 22287 | 22287 | 22197 22197 | 176 176 |
| 22288 | 22288 | 22198 22198 | 176 176 |
| 22289 | 22289 | 22199 22199 | 176 176 |
| 23346 | 23346 | 23242 23242 | 176 176 |
| 23752 | 23752 | 23642 23642 | 176 176 |
| 26197 | 26197 | 26095 26095 | 176 176 |
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) );