albums_labels
5 rows where label_id = 4573
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 24934 | 24934 | 22370 22370 | Gammon 4573 |
| 25094 | 25094 | 22526 22526 | Gammon 4573 |
| 26661 | 26661 | 24027 24027 | Gammon 4573 |
| 27682 | 27682 | 24974 24974 | Gammon 4573 |
| 28237 | 28237 | 25481 25481 | Gammon 4573 |
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) );