albums_labels
33 rows where label_id = 1940
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 6618 | 6618 | 5760 5760 | Fire 1940 |
| 6619 | 6619 | 5761 5761 | Fire 1940 |
| 6620 | 6620 | 5762 5762 | Fire 1940 |
| 6621 | 6621 | 5763 5763 | Fire 1940 |
| 6642 | 6642 | 5780 5780 | Fire 1940 |
| 7064 | 7064 | 6151 6151 | Fire 1940 |
| 7947 | 7947 | 6916 6916 | Fire 1940 |
| 8085 | 8085 | 7040 7040 | Fire 1940 |
| 9762 | 9762 | 8544 8544 | Fire 1940 |
| 10148 | 10148 | 8878 8878 | Fire 1940 |
| 13303 | 13303 | 11707 11707 | Fire 1940 |
| 14210 | 14210 | 12535 12535 | Fire 1940 |
| 14369 | 14369 | 12688 12688 | Fire 1940 |
| 14418 | 14418 | 12735 12735 | Fire 1940 |
| 14771 | 14771 | 13045 13045 | Fire 1940 |
| 14912 | 14912 | 13166 13166 | Fire 1940 |
| 15089 | 15089 | 13324 13324 | Fire 1940 |
| 15138 | 15138 | 13372 13372 | Fire 1940 |
| 15632 | 15632 | 13806 13806 | Fire 1940 |
| 15633 | 15633 | 13807 13807 | Fire 1940 |
| 15634 | 15634 | 13808 13808 | Fire 1940 |
| 15678 | 15678 | 13840 13840 | Fire 1940 |
| 15858 | 15858 | 14001 14001 | Fire 1940 |
| 15941 | 15941 | 14074 14074 | Fire 1940 |
| 16346 | 16346 | 14435 14435 | Fire 1940 |
| 16412 | 16412 | 14493 14493 | Fire 1940 |
| 16480 | 16480 | 14551 14551 | Fire 1940 |
| 16490 | 16490 | 14561 14561 | Fire 1940 |
| 16721 | 16721 | 14761 14761 | Fire 1940 |
| 18899 | 18899 | 16754 16754 | Fire 1940 |
| 23103 | 23103 | 20637 20637 | Fire 1940 |
| 23884 | 23884 | 21377 21377 | Fire 1940 |
| 24896 | 24896 | 22332 22332 | Fire 1940 |
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) );