albums_labels
8 rows where label_id = 2266
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8433 | 8433 | 7347 7347 | Cuneiform 2266 |
| 16963 | 16963 | 14984 14984 | Cuneiform 2266 |
| 18833 | 18833 | 16697 16697 | Cuneiform 2266 |
| 20746 | 20746 | 18484 18484 | Cuneiform 2266 |
| 22905 | 22905 | 20450 20450 | Cuneiform 2266 |
| 25063 | 25063 | 22499 22499 | Cuneiform 2266 |
| 26150 | 26150 | 23535 23535 | Cuneiform 2266 |
| 27021 | 27021 | 24361 24361 | Cuneiform 2266 |
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) );