albums_labels
6 rows where label_id = 2389
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9188 | 9188 | 8035 8035 | Easy Sound 2389 |
| 10647 | 10647 | 9317 9317 | Easy Sound 2389 |
| 10741 | 10741 | 9400 9400 | Easy Sound 2389 |
| 10966 | 10966 | 9601 9601 | Easy Sound 2389 |
| 11310 | 11310 | 9893 9893 | Easy Sound 2389 |
| 11933 | 11933 | 10442 10442 | Easy Sound 2389 |
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) );