albums_labels
21 rows where label_id = 239
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 355 | 355 | 304 304 | Triple Crown 239 |
| 1009 | 1009 | 861 861 | Triple Crown 239 |
| 1697 | 1697 | 1478 1478 | Triple Crown 239 |
| 3486 | 3486 | 3046 3046 | Triple Crown 239 |
| 3958 | 3958 | 3459 3459 | Triple Crown 239 |
| 4262 | 4262 | 3727 3727 | Triple Crown 239 |
| 5712 | 5712 | 4970 4970 | Triple Crown 239 |
| 7469 | 7469 | 6498 6498 | Triple Crown 239 |
| 7801 | 7801 | 6791 6791 | Triple Crown 239 |
| 8224 | 8224 | 7166 7166 | Triple Crown 239 |
| 8403 | 8403 | 7319 7319 | Triple Crown 239 |
| 9240 | 9240 | 8081 8081 | Triple Crown 239 |
| 9807 | 9807 | 8579 8579 | Triple Crown 239 |
| 12047 | 12047 | 10546 10546 | Triple Crown 239 |
| 12657 | 12657 | 11112 11112 | Triple Crown 239 |
| 14021 | 14021 | 12357 12357 | Triple Crown 239 |
| 15922 | 15922 | 14057 14057 | Triple Crown 239 |
| 18099 | 18099 | 16021 16021 | Triple Crown 239 |
| 22198 | 22198 | 19807 19807 | Triple Crown 239 |
| 28671 | 28671 | 25877 25877 | Triple Crown 239 |
| 29533 | 29533 | 26627 26627 | Triple Crown 239 |
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) );