albums_labels
11 rows where label_id = 1864
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 6299 | 6299 | 5484 5484 | Columbia Legacy 1864 |
| 6834 | 6834 | 5959 5959 | Columbia Legacy 1864 |
| 8167 | 8167 | 7116 7116 | Columbia Legacy 1864 |
| 8504 | 8504 | 7414 7414 | Columbia Legacy 1864 |
| 13410 | 13410 | 11803 11803 | Columbia Legacy 1864 |
| 14767 | 14767 | 13041 13041 | Columbia Legacy 1864 |
| 19440 | 19440 | 17291 17291 | Columbia Legacy 1864 |
| 20611 | 20611 | 18365 18365 | Columbia Legacy 1864 |
| 20620 | 20620 | 18371 18371 | Columbia Legacy 1864 |
| 22049 | 22049 | 19669 19669 | Columbia Legacy 1864 |
| 26035 | 26035 | 23425 23425 | Columbia Legacy 1864 |
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) );