albums_labels
5 rows where label_id = 4409
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 23486 | 23486 | 21000 21000 | Novamute 4409 |
| 27463 | 27463 | 24769 24769 | Novamute 4409 |
| 27613 | 27613 | 24909 24909 | Novamute 4409 |
| 28174 | 28174 | 25424 25424 | Novamute 4409 |
| 28235 | 28235 | 25479 25479 | Novamute 4409 |
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) );