albums_labels
9 rows where label_id = 831
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1926 | 1926 | 1683 1683 | United Souls 831 |
| 1928 | 1928 | 1684 1684 | United Souls 831 |
| 1929 | 1929 | 1685 1685 | United Souls 831 |
| 1930 | 1930 | 1686 1686 | United Souls 831 |
| 1931 | 1931 | 1687 1687 | United Souls 831 |
| 1932 | 1932 | 1688 1688 | United Souls 831 |
| 1933 | 1933 | 1689 1689 | United Souls 831 |
| 1934 | 1934 | 1690 1690 | United Souls 831 |
| 1935 | 1935 | 1691 1691 | United Souls 831 |
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) );