albums_labels
5 rows where label_id = 4091
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 21126 | 21126 | 18830 18830 | Fusetron 4091 |
| 23625 | 23625 | 21134 21134 | Fusetron 4091 |
| 24661 | 24661 | 22107 22107 | Fusetron 4091 |
| 25091 | 25091 | 22523 22523 | Fusetron 4091 |
| 25955 | 25955 | 23350 23350 | Fusetron 4091 |
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) );