albums_labels
11 rows where label_id = 115
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 131 | 131 | 113 113 | Keeled Scales 115 |
| 167 | 167 | 143 143 | Keeled Scales 115 |
| 429 | 429 | 366 366 | Keeled Scales 115 |
| 891 | 891 | 762 762 | Keeled Scales 115 |
| 2159 | 2159 | 1877 1877 | Keeled Scales 115 |
| 2360 | 2360 | 2052 2052 | Keeled Scales 115 |
| 2412 | 2412 | 2100 2100 | Keeled Scales 115 |
| 3153 | 3153 | 2757 2757 | Keeled Scales 115 |
| 4523 | 4523 | 3947 3947 | Keeled Scales 115 |
| 6070 | 6070 | 5281 5281 | Keeled Scales 115 |
| 30031 | 30031 | 27059 27059 | Keeled Scales 115 |
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) );