albums_labels
6 rows where label_id = 397
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 663 | 663 | 557 557 | Night Time Stories Ltd. 397 |
| 3090 | 3090 | 2702 2702 | Night Time Stories Ltd. 397 |
| 3637 | 3637 | 3171 3171 | Night Time Stories Ltd. 397 |
| 4398 | 4398 | 3838 3838 | Night Time Stories Ltd. 397 |
| 6535 | 6535 | 5687 5687 | Night Time Stories Ltd. 397 |
| 7232 | 7232 | 6294 6294 | Night Time Stories Ltd. 397 |
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) );