albums_labels
3 rows where label_id = 264
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 401 | 401 | 342 342 | Modern 264 |
| 3507 | 3507 | 3064 3064 | Modern 264 |
| 29733 | 29733 | 26798 26798 | Modern 264 |
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) );