albums_labels
14 rows where label_id = 701
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1488 | 1488 | 1288 1288 | 100% Silk 701 |
| 3252 | 3252 | 2845 2845 | 100% Silk 701 |
| 3807 | 3807 | 3324 3324 | 100% Silk 701 |
| 4989 | 4989 | 4357 4357 | 100% Silk 701 |
| 8023 | 8023 | 6985 6985 | 100% Silk 701 |
| 10510 | 10510 | 9197 9197 | 100% Silk 701 |
| 12221 | 12221 | 10704 10704 | 100% Silk 701 |
| 13007 | 13007 | 11428 11428 | 100% Silk 701 |
| 13205 | 13205 | 11612 11612 | 100% Silk 701 |
| 13250 | 13250 | 11655 11655 | 100% Silk 701 |
| 14828 | 14828 | 13099 13099 | 100% Silk 701 |
| 14852 | 14852 | 13120 13120 | 100% Silk 701 |
| 15033 | 15033 | 13274 13274 | 100% Silk 701 |
| 15197 | 15197 | 13423 13423 | 100% Silk 701 |
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) );