albums_labels
29 rows where label_id = 1040
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 2582 | 2582 | 2250 2250 | Caroline 1040 |
| 2605 | 2605 | 2270 2270 | Caroline 1040 |
| 3128 | 3128 | 2734 2734 | Caroline 1040 |
| 3311 | 3311 | 2894 2894 | Caroline 1040 |
| 3966 | 3966 | 3465 3465 | Caroline 1040 |
| 4158 | 4158 | 3640 3640 | Caroline 1040 |
| 4276 | 4276 | 3738 3738 | Caroline 1040 |
| 4283 | 4283 | 3743 3743 | Caroline 1040 |
| 4290 | 4290 | 3747 3747 | Caroline 1040 |
| 5293 | 5293 | 4611 4611 | Caroline 1040 |
| 5703 | 5703 | 4963 4963 | Caroline 1040 |
| 6251 | 6251 | 5442 5442 | Caroline 1040 |
| 6852 | 6852 | 5972 5972 | Caroline 1040 |
| 7011 | 7011 | 6106 6106 | Caroline 1040 |
| 7552 | 7552 | 6574 6574 | Caroline 1040 |
| 7640 | 7640 | 6652 6652 | Caroline 1040 |
| 8591 | 8591 | 7494 7494 | Caroline 1040 |
| 8630 | 8630 | 7525 7525 | Caroline 1040 |
| 9226 | 9226 | 8069 8069 | Caroline 1040 |
| 9328 | 9328 | 8158 8158 | Caroline 1040 |
| 10905 | 10905 | 9545 9545 | Caroline 1040 |
| 11779 | 11779 | 10311 10311 | Caroline 1040 |
| 11792 | 11792 | 10323 10323 | Caroline 1040 |
| 14452 | 14452 | 12766 12766 | Caroline 1040 |
| 21762 | 21762 | 19406 19406 | Caroline 1040 |
| 24224 | 24224 | 21695 21695 | Caroline 1040 |
| 24328 | 24328 | 21797 21797 | Caroline 1040 |
| 26174 | 26174 | 23558 23558 | Caroline 1040 |
| 26336 | 26336 | 23712 23712 | Caroline 1040 |
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) );