albums_labels
3 rows where label_id = 4886
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 27037 | 27037 | 24378 24378 | Incidental 4886 |
| 27950 | 27950 | 25223 25223 | Incidental 4886 |
| 27998 | 27998 | 25267 25267 | Incidental 4886 |
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) );