albums_labels
6 rows where label_id = 693
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1463 | 1463 | 1269 1269 | Southeastern 693 |
| 3245 | 3245 | 2839 2839 | Southeastern 693 |
| 7432 | 7432 | 6466 6466 | Southeastern 693 |
| 10288 | 10288 | 9001 9001 | Southeastern 693 |
| 13022 | 13022 | 11440 11440 | Southeastern 693 |
| 29654 | 29654 | 26731 26731 | Southeastern 693 |
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) );