albums_labels
9 rows where label_id = 1074
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 2716 | 2716 | 2370 2370 | Godmode 1074 |
| 4248 | 4248 | 3715 3715 | Godmode 1074 |
| 5749 | 5749 | 5004 5004 | Godmode 1074 |
| 6821 | 6821 | 5947 5947 | Godmode 1074 |
| 7768 | 7768 | 6762 6762 | Godmode 1074 |
| 11630 | 11630 | 10178 10178 | Godmode 1074 |
| 11785 | 11785 | 10317 10317 | Godmode 1074 |
| 12565 | 12565 | 11024 11024 | Godmode 1074 |
| 14885 | 14885 | 13145 13145 | Godmode 1074 |
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) );