albums_labels
8 rows where label_id = 4334
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 22840 | 22840 | 20392 20392 | Gern Blandsten 4334 |
| 26518 | 26518 | 23888 23888 | Gern Blandsten 4334 |
| 26796 | 26796 | 24155 24155 | Gern Blandsten 4334 |
| 27409 | 27409 | 24719 24719 | Gern Blandsten 4334 |
| 27660 | 27660 | 24954 24954 | Gern Blandsten 4334 |
| 28183 | 28183 | 25432 25432 | Gern Blandsten 4334 |
| 28274 | 28274 | 25515 25515 | Gern Blandsten 4334 |
| 28744 | 28744 | 25945 25945 | Gern Blandsten 4334 |
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) );