albums_labels
21 rows where label_id = 427
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 732 | 732 | 620 620 | Father/Daughter 427 |
| 1325 | 1325 | 1139 1139 | Father/Daughter 427 |
| 2164 | 2164 | 1882 1882 | Father/Daughter 427 |
| 2701 | 2701 | 2359 2359 | Father/Daughter 427 |
| 3168 | 3168 | 2771 2771 | Father/Daughter 427 |
| 3894 | 3894 | 3403 3403 | Father/Daughter 427 |
| 4237 | 4237 | 3705 3705 | Father/Daughter 427 |
| 4564 | 4564 | 3985 3985 | Father/Daughter 427 |
| 4777 | 4777 | 4171 4171 | Father/Daughter 427 |
| 4987 | 4987 | 4355 4355 | Father/Daughter 427 |
| 5199 | 5199 | 4537 4537 | Father/Daughter 427 |
| 5353 | 5353 | 4662 4662 | Father/Daughter 427 |
| 6546 | 6546 | 5695 5695 | Father/Daughter 427 |
| 6759 | 6759 | 5888 5888 | Father/Daughter 427 |
| 6841 | 6841 | 5963 5963 | Father/Daughter 427 |
| 7681 | 7681 | 6690 6690 | Father/Daughter 427 |
| 7894 | 7894 | 6871 6871 | Father/Daughter 427 |
| 10043 | 10043 | 8785 8785 | Father/Daughter 427 |
| 10847 | 10847 | 9494 9494 | Father/Daughter 427 |
| 12838 | 12838 | 11275 11275 | Father/Daughter 427 |
| 29366 | 29366 | 26480 26480 | Father/Daughter 427 |
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) );