albums_labels
30 rows where label_id = 2188
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8024 | 8024 | 6986 6986 | Hometapes 2188 |
| 11177 | 11177 | 9781 9781 | Hometapes 2188 |
| 11614 | 11614 | 10163 10163 | Hometapes 2188 |
| 12530 | 12530 | 10993 10993 | Hometapes 2188 |
| 12636 | 12636 | 11092 11092 | Hometapes 2188 |
| 12752 | 12752 | 11197 11197 | Hometapes 2188 |
| 14760 | 14760 | 13036 13036 | Hometapes 2188 |
| 14777 | 14777 | 13050 13050 | Hometapes 2188 |
| 15494 | 15494 | 13690 13690 | Hometapes 2188 |
| 15616 | 15616 | 13793 13793 | Hometapes 2188 |
| 16180 | 16180 | 14285 14285 | Hometapes 2188 |
| 16309 | 16309 | 14404 14404 | Hometapes 2188 |
| 16571 | 16571 | 14635 14635 | Hometapes 2188 |
| 16854 | 16854 | 14886 14886 | Hometapes 2188 |
| 16873 | 16873 | 14905 14905 | Hometapes 2188 |
| 16981 | 16981 | 15002 15002 | Hometapes 2188 |
| 18013 | 18013 | 15938 15938 | Hometapes 2188 |
| 18106 | 18106 | 16027 16027 | Hometapes 2188 |
| 18399 | 18399 | 16303 16303 | Hometapes 2188 |
| 19824 | 19824 | 17665 17665 | Hometapes 2188 |
| 19968 | 19968 | 17797 17797 | Hometapes 2188 |
| 20629 | 20629 | 18379 18379 | Hometapes 2188 |
| 20645 | 20645 | 18393 18393 | Hometapes 2188 |
| 20800 | 20800 | 18530 18530 | Hometapes 2188 |
| 21378 | 21378 | 19060 19060 | Hometapes 2188 |
| 21393 | 21393 | 19074 19074 | Hometapes 2188 |
| 21993 | 21993 | 19618 19618 | Hometapes 2188 |
| 23147 | 23147 | 20678 20678 | Hometapes 2188 |
| 23369 | 23369 | 20894 20894 | Hometapes 2188 |
| 25344 | 25344 | 22767 22767 | Hometapes 2188 |
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) );