albums_labels
4 rows where label_id = 788
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1756 | 1756 | 1531 1531 | Stinc Team 788 |
| 2265 | 2265 | 1971 1971 | Stinc Team 788 |
| 3146 | 3146 | 2751 2751 | Stinc Team 788 |
| 6637 | 6637 | 5777 5777 | Stinc Team 788 |
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) );