albums_artists
23 rows where artist_id = 268
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 275 | 275 | 263 263 | 268 268 |
| 658 | 658 | 631 631 | 268 268 |
| 2409 | 2409 | 2259 2259 | 268 268 |
| 3747 | 3747 | 3548 3548 | 268 268 |
| 6131 | 6131 | 5853 5853 | 268 268 |
| 6132 | 6132 | 5854 5854 | 268 268 |
| 7809 | 7809 | 7497 7497 | 268 268 |
| 9318 | 9318 | 8971 8971 | 268 268 |
| 10094 | 10094 | 9749 9749 | 268 268 |
| 10095 | 10095 | 9750 9750 | 268 268 |
| 13301 | 13301 | 12954 12954 | 268 268 |
| 13615 | 13615 | 13265 13265 | 268 268 |
| 14020 | 14020 | 13666 13666 | 268 268 |
| 16707 | 16707 | 16397 16397 | 268 268 |
| 19285 | 19285 | 19067 19067 | 268 268 |
| 21068 | 21068 | 20929 20929 | 268 268 |
| 22324 | 22324 | 22234 22234 | 268 268 |
| 22775 | 22775 | 22685 22685 | 268 268 |
| 24082 | 24082 | 23972 23972 | 268 268 |
| 25069 | 25069 | 24964 24964 | 268 268 |
| 25995 | 25995 | 25895 25895 | 268 268 |
| 26387 | 26387 | 26281 26281 | 268 268 |
| 27176 | 27176 | 27016 27016 | 268 268 |
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) );