albums_labels
70 rows where label_id = 38
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 45 | 45 | 40 40 | Warner 38 |
| 77 | 77 | 69 69 | Warner 38 |
| 126 | 126 | 109 109 | Warner 38 |
| 207 | 207 | 179 179 | Warner 38 |
| 264 | 264 | 228 228 | Warner 38 |
| 325 | 325 | 278 278 | Warner 38 |
| 395 | 395 | 336 336 | Warner 38 |
| 410 | 410 | 349 349 | Warner 38 |
| 643 | 643 | 540 540 | Warner 38 |
| 656 | 656 | 551 551 | Warner 38 |
| 658 | 658 | 553 553 | Warner 38 |
| 895 | 895 | 766 766 | Warner 38 |
| 969 | 969 | 827 827 | Warner 38 |
| 1088 | 1088 | 933 933 | Warner 38 |
| 1124 | 1124 | 966 966 | Warner 38 |
| 1188 | 1188 | 1021 1021 | Warner 38 |
| 1223 | 1223 | 1054 1054 | Warner 38 |
| 1253 | 1253 | 1080 1080 | Warner 38 |
| 1395 | 1395 | 1204 1204 | Warner 38 |
| 1427 | 1427 | 1236 1236 | Warner 38 |
| 1473 | 1473 | 1275 1275 | Warner 38 |
| 1699 | 1699 | 1480 1480 | Warner 38 |
| 1721 | 1721 | 1499 1499 | Warner 38 |
| 1760 | 1760 | 1535 1535 | Warner 38 |
| 1798 | 1798 | 1570 1570 | Warner 38 |
| 1815 | 1815 | 1589 1589 | Warner 38 |
| 2239 | 2239 | 1949 1949 | Warner 38 |
| 2293 | 2293 | 1996 1996 | Warner 38 |
| 2410 | 2410 | 2098 2098 | Warner 38 |
| 2620 | 2620 | 2285 2285 | Warner 38 |
| 2651 | 2651 | 2312 2312 | Warner 38 |
| 2663 | 2663 | 2322 2322 | Warner 38 |
| 2685 | 2685 | 2344 2344 | Warner 38 |
| 2711 | 2711 | 2367 2367 | Warner 38 |
| 2720 | 2720 | 2374 2374 | Warner 38 |
| 2752 | 2752 | 2402 2402 | Warner 38 |
| 2754 | 2754 | 2403 2403 | Warner 38 |
| 2756 | 2756 | 2404 2404 | Warner 38 |
| 2758 | 2758 | 2405 2405 | Warner 38 |
| 2760 | 2760 | 2406 2406 | Warner 38 |
| 2762 | 2762 | 2407 2407 | Warner 38 |
| 2764 | 2764 | 2408 2408 | Warner 38 |
| 2808 | 2808 | 2447 2447 | Warner 38 |
| 2839 | 2839 | 2475 2475 | Warner 38 |
| 2853 | 2853 | 2489 2489 | Warner 38 |
| 3130 | 3130 | 2735 2735 | Warner 38 |
| 3133 | 3133 | 2738 2738 | Warner 38 |
| 3223 | 3223 | 2818 2818 | Warner 38 |
| 3436 | 3436 | 3004 3004 | Warner 38 |
| 3526 | 3526 | 3079 3079 | Warner 38 |
| 3645 | 3645 | 3178 3178 | Warner 38 |
| 3720 | 3720 | 3242 3242 | Warner 38 |
| 3736 | 3736 | 3257 3257 | Warner 38 |
| 3815 | 3815 | 3332 3332 | Warner 38 |
| 3951 | 3951 | 3452 3452 | Warner 38 |
| 3997 | 3997 | 3495 3495 | Warner 38 |
| 4128 | 4128 | 3615 3615 | Warner 38 |
| 4163 | 4163 | 3644 3644 | Warner 38 |
| 29160 | 29160 | 26305 26305 | Warner 38 |
| 29307 | 29307 | 26432 26432 | Warner 38 |
| 29371 | 29371 | 26485 26485 | Warner 38 |
| 29605 | 29605 | 26689 26689 | Warner 38 |
| 29858 | 29858 | 26904 26904 | Warner 38 |
| 29895 | 29895 | 26935 26935 | Warner 38 |
| 29903 | 29903 | 26941 26941 | Warner 38 |
| 29957 | 29957 | 26990 26990 | Warner 38 |
| 30092 | 30092 | 27114 27114 | Warner 38 |
| 30119 | 30119 | 27140 27140 | Warner 38 |
| 30285 | 30285 | 27289 27289 | Warner 38 |
| 30431 | 30431 | 27422 27422 | Warner 38 |
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) );