albums_labels
6 rows where label_id = 4466
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 24012 | 24012 | 21499 21499 | Mo'Wax 4466 |
| 25755 | 25755 | 23159 23159 | Mo'Wax 4466 |
| 25909 | 25909 | 23306 23306 | Mo'Wax 4466 |
| 27755 | 27755 | 25041 25041 | Mo'Wax 4466 |
| 27841 | 27841 | 25119 25119 | Mo'Wax 4466 |
| 27974 | 27974 | 25245 25245 | Mo'Wax 4466 |
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) );