albums_labels
5 rows where label_id = 2353
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8924 | 8924 | 7791 7791 | Twosyllable 2353 |
| 13079 | 13079 | 11493 11493 | Twosyllable 2353 |
| 17020 | 17020 | 15038 15038 | Twosyllable 2353 |
| 17405 | 17405 | 15377 15377 | Twosyllable 2353 |
| 18179 | 18179 | 16092 16092 | Twosyllable 2353 |
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) );