albums_labels
13 rows where label_id = 2066
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 7297 | 7297 | 6348 6348 | Dais Records 2066 |
| 7299 | 7299 | 6349 6349 | Dais Records 2066 |
| 7618 | 7618 | 6633 6633 | Dais Records 2066 |
| 7772 | 7772 | 6766 6766 | Dais Records 2066 |
| 8508 | 8508 | 7418 7418 | Dais Records 2066 |
| 9235 | 9235 | 8076 8076 | Dais Records 2066 |
| 9973 | 9973 | 8721 8721 | Dais Records 2066 |
| 10422 | 10422 | 9117 9117 | Dais Records 2066 |
| 11408 | 11408 | 9980 9980 | Dais Records 2066 |
| 11715 | 11715 | 10255 10255 | Dais Records 2066 |
| 12307 | 12307 | 10786 10786 | Dais Records 2066 |
| 12702 | 12702 | 11152 11152 | Dais Records 2066 |
| 13934 | 13934 | 12279 12279 | Dais Records 2066 |
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) );