albums_artists
26 rows where artist_id = 2363
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 2895 | 2895 | 2726 2726 | 2363 2363 |
| 3636 | 3636 | 3440 3440 | 2363 2363 |
| 4138 | 4138 | 3937 3937 | 2363 2363 |
| 4873 | 4873 | 4647 4647 | 2363 2363 |
| 5564 | 5564 | 5305 5305 | 2363 2363 |
| 6242 | 6242 | 5959 5959 | 2363 2363 |
| 7035 | 7035 | 6735 6735 | 2363 2363 |
| 7416 | 7416 | 7116 7116 | 2363 2363 |
| 7601 | 7601 | 7294 7294 | 2363 2363 |
| 8238 | 8238 | 7918 7918 | 2363 2363 |
| 8925 | 8925 | 8589 8589 | 2363 2363 |
| 9922 | 9922 | 9576 9576 | 2363 2363 |
| 11596 | 11596 | 11258 11258 | 2363 2363 |
| 12808 | 12808 | 12466 12466 | 2363 2363 |
| 14581 | 14581 | 14227 14227 | 2363 2363 |
| 15072 | 15072 | 14727 14727 | 2363 2363 |
| 16308 | 16308 | 15993 15993 | 2363 2363 |
| 16920 | 16920 | 16612 16612 | 2363 2363 |
| 17525 | 17525 | 17230 17230 | 2363 2363 |
| 18808 | 18808 | 18565 18565 | 2363 2363 |
| 20115 | 20115 | 19937 19937 | 2363 2363 |
| 21313 | 21313 | 21188 21188 | 2363 2363 |
| 23006 | 23006 | 22911 22911 | 2363 2363 |
| 26472 | 26472 | 26362 26362 | 2363 2363 |
| 27361 | 27361 | 27190 27190 | 2363 2363 |
| 27449 | 27449 | 27274 27274 | 2363 2363 |
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) );