albums_labels
34 rows where label_id = 2965
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 13028 | 13028 | 11444 11444 | Leaf 2965 |
| 14472 | 14472 | 12783 12783 | Leaf 2965 |
| 14776 | 14776 | 13050 13050 | Leaf 2965 |
| 18009 | 18009 | 15935 15935 | Leaf 2965 |
| 18301 | 18301 | 16209 16209 | Leaf 2965 |
| 18679 | 18679 | 16561 16561 | Leaf 2965 |
| 18713 | 18713 | 16594 16594 | Leaf 2965 |
| 19422 | 19422 | 17273 17273 | Leaf 2965 |
| 19904 | 19904 | 17739 17739 | Leaf 2965 |
| 20367 | 20367 | 18138 18138 | Leaf 2965 |
| 20640 | 20640 | 18389 18389 | Leaf 2965 |
| 20952 | 20952 | 18668 18668 | Leaf 2965 |
| 22505 | 22505 | 20084 20084 | Leaf 2965 |
| 23184 | 23184 | 20715 20715 | Leaf 2965 |
| 23802 | 23802 | 21298 21298 | Leaf 2965 |
| 23948 | 23948 | 21437 21437 | Leaf 2965 |
| 24181 | 24181 | 21654 21654 | Leaf 2965 |
| 24207 | 24207 | 21680 21680 | Leaf 2965 |
| 24636 | 24636 | 22082 22082 | Leaf 2965 |
| 24644 | 24644 | 22090 22090 | Leaf 2965 |
| 24857 | 24857 | 22293 22293 | Leaf 2965 |
| 25140 | 25140 | 22569 22569 | Leaf 2965 |
| 25833 | 25833 | 23235 23235 | Leaf 2965 |
| 26207 | 26207 | 23589 23589 | Leaf 2965 |
| 26552 | 26552 | 23920 23920 | Leaf 2965 |
| 26678 | 26678 | 24043 24043 | Leaf 2965 |
| 26724 | 26724 | 24087 24087 | Leaf 2965 |
| 26739 | 26739 | 24102 24102 | Leaf 2965 |
| 26971 | 26971 | 24316 24316 | Leaf 2965 |
| 27058 | 27058 | 24395 24395 | Leaf 2965 |
| 27793 | 27793 | 25077 25077 | Leaf 2965 |
| 28333 | 28333 | 25572 25572 | Leaf 2965 |
| 28620 | 28620 | 25833 25833 | Leaf 2965 |
| 28698 | 28698 | 25903 25903 | Leaf 2965 |
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) );