albums_labels
39 rows where label_id = 2501
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9882 | 9882 | 8643 8643 | Jade Tree 2501 |
| 10256 | 10256 | 8973 8973 | Jade Tree 2501 |
| 10896 | 10896 | 9538 9538 | Jade Tree 2501 |
| 20822 | 20822 | 18551 18551 | Jade Tree 2501 |
| 21639 | 21639 | 19295 19295 | Jade Tree 2501 |
| 21758 | 21758 | 19402 19402 | Jade Tree 2501 |
| 22062 | 22062 | 19682 19682 | Jade Tree 2501 |
| 22371 | 22371 | 19963 19963 | Jade Tree 2501 |
| 22542 | 22542 | 20116 20116 | Jade Tree 2501 |
| 22789 | 22789 | 20345 20345 | Jade Tree 2501 |
| 23603 | 23603 | 21113 21113 | Jade Tree 2501 |
| 23799 | 23799 | 21295 21295 | Jade Tree 2501 |
| 23999 | 23999 | 21486 21486 | Jade Tree 2501 |
| 24013 | 24013 | 21500 21500 | Jade Tree 2501 |
| 24654 | 24654 | 22100 22100 | Jade Tree 2501 |
| 24943 | 24943 | 22379 22379 | Jade Tree 2501 |
| 25264 | 25264 | 22689 22689 | Jade Tree 2501 |
| 25357 | 25357 | 22780 22780 | Jade Tree 2501 |
| 25465 | 25465 | 22882 22882 | Jade Tree 2501 |
| 25535 | 25535 | 22946 22946 | Jade Tree 2501 |
| 25687 | 25687 | 23092 23092 | Jade Tree 2501 |
| 25774 | 25774 | 23178 23178 | Jade Tree 2501 |
| 25978 | 25978 | 23369 23369 | Jade Tree 2501 |
| 26727 | 26727 | 24090 24090 | Jade Tree 2501 |
| 26733 | 26733 | 24096 24096 | Jade Tree 2501 |
| 27151 | 27151 | 24479 24479 | Jade Tree 2501 |
| 27280 | 27280 | 24595 24595 | Jade Tree 2501 |
| 27353 | 27353 | 24665 24665 | Jade Tree 2501 |
| 27654 | 27654 | 24949 24949 | Jade Tree 2501 |
| 27673 | 27673 | 24966 24966 | Jade Tree 2501 |
| 27718 | 27718 | 25009 25009 | Jade Tree 2501 |
| 27877 | 27877 | 25153 25153 | Jade Tree 2501 |
| 28170 | 28170 | 25420 25420 | Jade Tree 2501 |
| 28396 | 28396 | 25629 25629 | Jade Tree 2501 |
| 28557 | 28557 | 25775 25775 | Jade Tree 2501 |
| 28636 | 28636 | 25848 25848 | Jade Tree 2501 |
| 28769 | 28769 | 25968 25968 | Jade Tree 2501 |
| 28865 | 28865 | 26054 26054 | Jade Tree 2501 |
| 29078 | 29078 | 26237 26237 | Jade Tree 2501 |
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) );