albums_labels
21 rows where label_id = 1958
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 6692 | 6692 | 5826 5826 | Honest Jon's 1958 |
| 8064 | 8064 | 7020 7020 | Honest Jon's 1958 |
| 8359 | 8359 | 7283 7283 | Honest Jon's 1958 |
| 8823 | 8823 | 7702 7702 | Honest Jon's 1958 |
| 9672 | 9672 | 8458 8458 | Honest Jon's 1958 |
| 10408 | 10408 | 9106 9106 | Honest Jon's 1958 |
| 10865 | 10865 | 9511 9511 | Honest Jon's 1958 |
| 14674 | 14674 | 12959 12959 | Honest Jon's 1958 |
| 14857 | 14857 | 13122 13122 | Honest Jon's 1958 |
| 14864 | 14864 | 13128 13128 | Honest Jon's 1958 |
| 15233 | 15233 | 13456 13456 | Honest Jon's 1958 |
| 15790 | 15790 | 13939 13939 | Honest Jon's 1958 |
| 16215 | 16215 | 14318 14318 | Honest Jon's 1958 |
| 16978 | 16978 | 14999 14999 | Honest Jon's 1958 |
| 17185 | 17185 | 15190 15190 | Honest Jon's 1958 |
| 19166 | 19166 | 17019 17019 | Honest Jon's 1958 |
| 19196 | 19196 | 17049 17049 | Honest Jon's 1958 |
| 19674 | 19674 | 17519 17519 | Honest Jon's 1958 |
| 21740 | 21740 | 19388 19388 | Honest Jon's 1958 |
| 25634 | 25634 | 23041 23041 | Honest Jon's 1958 |
| 25855 | 25855 | 23254 23254 | Honest Jon's 1958 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE albums_labels ( album_id integer NOT NULL, label_id integer NOT NULL, FOREIGN KEY(album_id) REFERENCES albums(id), FOREIGN KEY(label_id) REFERENCES labels(id), UNIQUE(album_id,label_id) );