albums_labels
5 rows where label_id = 4856
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 26842 | 26842 | 24197 24197 | Squealer 4856 |
| 26953 | 26953 | 24299 24299 | Squealer 4856 |
| 27107 | 27107 | 24437 24437 | Squealer 4856 |
| 27385 | 27385 | 24696 24696 | Squealer 4856 |
| 28232 | 28232 | 25476 25476 | Squealer 4856 |
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) );