albums_labels
38 rows where label_id = 1142
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 2995 | 2995 | 2620 2620 | Strut 1142 |
| 3039 | 3039 | 2659 2659 | Strut 1142 |
| 3991 | 3991 | 3489 3489 | Strut 1142 |
| 4354 | 4354 | 3803 3803 | Strut 1142 |
| 6398 | 6398 | 5569 5569 | Strut 1142 |
| 7521 | 7521 | 6546 6546 | Strut 1142 |
| 8217 | 8217 | 7159 7159 | Strut 1142 |
| 8442 | 8442 | 7355 7355 | Strut 1142 |
| 10682 | 10682 | 9350 9350 | Strut 1142 |
| 10927 | 10927 | 9563 9563 | Strut 1142 |
| 11332 | 11332 | 9912 9912 | Strut 1142 |
| 11724 | 11724 | 10262 10262 | Strut 1142 |
| 12208 | 12208 | 10692 10692 | Strut 1142 |
| 12272 | 12272 | 10752 10752 | Strut 1142 |
| 12887 | 12887 | 11318 11318 | Strut 1142 |
| 13365 | 13365 | 11761 11761 | Strut 1142 |
| 13452 | 13452 | 11842 11842 | Strut 1142 |
| 14384 | 14384 | 12703 12703 | Strut 1142 |
| 14634 | 14634 | 12928 12928 | Strut 1142 |
| 14827 | 14827 | 13098 13098 | Strut 1142 |
| 15047 | 15047 | 13287 13287 | Strut 1142 |
| 15342 | 15342 | 13552 13552 | Strut 1142 |
| 15812 | 15812 | 13959 13959 | Strut 1142 |
| 16179 | 16179 | 14284 14284 | Strut 1142 |
| 16339 | 16339 | 14429 14429 | Strut 1142 |
| 17019 | 17019 | 15037 15037 | Strut 1142 |
| 17545 | 17545 | 15503 15503 | Strut 1142 |
| 17907 | 17907 | 15839 15839 | Strut 1142 |
| 18321 | 18321 | 16227 16227 | Strut 1142 |
| 18852 | 18852 | 16716 16716 | Strut 1142 |
| 18921 | 18921 | 16775 16775 | Strut 1142 |
| 18987 | 18987 | 16840 16840 | Strut 1142 |
| 19986 | 19986 | 17812 17812 | Strut 1142 |
| 20003 | 20003 | 17827 17827 | Strut 1142 |
| 20478 | 20478 | 18242 18242 | Strut 1142 |
| 27335 | 27335 | 24648 24648 | Strut 1142 |
| 29579 | 29579 | 26667 26667 | Strut 1142 |
| 29685 | 29685 | 26756 26756 | Strut 1142 |
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) );