albums_labels
16 rows where label_id = 698
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1478 | 1478 | 1280 1280 | Fat Beats 698 |
| 1823 | 1823 | 1597 1597 | Fat Beats 698 |
| 2389 | 2389 | 2079 2079 | Fat Beats 698 |
| 7833 | 7833 | 6816 6816 | Fat Beats 698 |
| 12619 | 12619 | 11075 11075 | Fat Beats 698 |
| 14184 | 14184 | 12509 12509 | Fat Beats 698 |
| 15326 | 15326 | 13537 13537 | Fat Beats 698 |
| 15759 | 15759 | 13912 13912 | Fat Beats 698 |
| 16796 | 16796 | 14833 14833 | Fat Beats 698 |
| 16891 | 16891 | 14920 14920 | Fat Beats 698 |
| 18687 | 18687 | 16569 16569 | Fat Beats 698 |
| 19259 | 19259 | 17111 17111 | Fat Beats 698 |
| 19513 | 19513 | 17363 17363 | Fat Beats 698 |
| 25906 | 25906 | 23303 23303 | Fat Beats 698 |
| 27325 | 27325 | 24639 24639 | Fat Beats 698 |
| 27446 | 27446 | 24752 24752 | Fat Beats 698 |
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) );