albums_labels
220 rows where label_id = 29
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 35 | 35 | 32 32 | RCA 29 |
| 82 | 82 | 73 73 | RCA 29 |
| 85 | 85 | 76 76 | RCA 29 |
| 200 | 200 | 173 173 | RCA 29 |
| 227 | 227 | 195 195 | RCA 29 |
| 459 | 459 | 389 389 | RCA 29 |
| 542 | 542 | 454 454 | RCA 29 |
| 568 | 568 | 476 476 | RCA 29 |
| 731 | 731 | 619 619 | RCA 29 |
| 741 | 741 | 627 627 | RCA 29 |
| 790 | 790 | 669 669 | RCA 29 |
| 801 | 801 | 675 675 | RCA 29 |
| 944 | 944 | 805 805 | RCA 29 |
| 977 | 977 | 833 833 | RCA 29 |
| 982 | 982 | 837 837 | RCA 29 |
| 1120 | 1120 | 962 962 | RCA 29 |
| 1247 | 1247 | 1075 1075 | RCA 29 |
| 1460 | 1460 | 1265 1265 | RCA 29 |
| 1495 | 1495 | 1295 1295 | RCA 29 |
| 1520 | 1520 | 1317 1317 | RCA 29 |
| 1555 | 1555 | 1347 1347 | RCA 29 |
| 1687 | 1687 | 1468 1468 | RCA 29 |
| 1731 | 1731 | 1508 1508 | RCA 29 |
| 1775 | 1775 | 1548 1548 | RCA 29 |
| 1777 | 1777 | 1550 1550 | RCA 29 |
| 1780 | 1780 | 1554 1554 | RCA 29 |
| 1841 | 1841 | 1612 1612 | RCA 29 |
| 1854 | 1854 | 1623 1623 | RCA 29 |
| 1872 | 1872 | 1637 1637 | RCA 29 |
| 1891 | 1891 | 1652 1652 | RCA 29 |
| 1953 | 1953 | 1706 1706 | RCA 29 |
| 1957 | 1957 | 1710 1710 | RCA 29 |
| 2115 | 2115 | 1840 1840 | RCA 29 |
| 2178 | 2178 | 1895 1895 | RCA 29 |
| 2180 | 2180 | 1896 1896 | RCA 29 |
| 2250 | 2250 | 1957 1957 | RCA 29 |
| 2318 | 2318 | 2017 2017 | RCA 29 |
| 2354 | 2354 | 2047 2047 | RCA 29 |
| 2414 | 2414 | 2102 2102 | RCA 29 |
| 2426 | 2426 | 2113 2113 | RCA 29 |
| 2507 | 2507 | 2186 2186 | RCA 29 |
| 2591 | 2591 | 2257 2257 | RCA 29 |
| 2714 | 2714 | 2368 2368 | RCA 29 |
| 2770 | 2770 | 2413 2413 | RCA 29 |
| 2889 | 2889 | 2520 2520 | RCA 29 |
| 3074 | 3074 | 2691 2691 | RCA 29 |
| 3250 | 3250 | 2843 2843 | RCA 29 |
| 3382 | 3382 | 2956 2956 | RCA 29 |
| 3444 | 3444 | 3010 3010 | RCA 29 |
| 3522 | 3522 | 3076 3076 | RCA 29 |
| 3792 | 3792 | 3310 3310 | RCA 29 |
| 3871 | 3871 | 3382 3382 | RCA 29 |
| 3911 | 3911 | 3418 3418 | RCA 29 |
| 3986 | 3986 | 3484 3484 | RCA 29 |
| 4178 | 4178 | 3656 3656 | RCA 29 |
| 4186 | 4186 | 3663 3663 | RCA 29 |
| 4205 | 4205 | 3678 3678 | RCA 29 |
| 4211 | 4211 | 3682 3682 | RCA 29 |
| 4213 | 4213 | 3683 3683 | RCA 29 |
| 4234 | 4234 | 3702 3702 | RCA 29 |
| 4286 | 4286 | 3745 3745 | RCA 29 |
| 4316 | 4316 | 3767 3767 | RCA 29 |
| 4379 | 4379 | 3822 3822 | RCA 29 |
| 4446 | 4446 | 3882 3882 | RCA 29 |
| 4454 | 4454 | 3887 3887 | RCA 29 |
| 4491 | 4491 | 3919 3919 | RCA 29 |
| 4546 | 4546 | 3970 3970 | RCA 29 |
| 4686 | 4686 | 4089 4089 | RCA 29 |
| 4738 | 4738 | 4134 4134 | RCA 29 |
| 4775 | 4775 | 4169 4169 | RCA 29 |
| 5164 | 5164 | 4514 4514 | RCA 29 |
| 5261 | 5261 | 4588 4588 | RCA 29 |
| 5316 | 5316 | 4630 4630 | RCA 29 |
| 5434 | 5434 | 4732 4732 | RCA 29 |
| 5532 | 5532 | 4817 4817 | RCA 29 |
| 5592 | 5592 | 4868 4868 | RCA 29 |
| 5799 | 5799 | 5051 5051 | RCA 29 |
| 5915 | 5915 | 5158 5158 | RCA 29 |
| 5933 | 5933 | 5173 5173 | RCA 29 |
| 5946 | 5946 | 5184 5184 | RCA 29 |
| 6012 | 6012 | 5242 5242 | RCA 29 |
| 6200 | 6200 | 5397 5397 | RCA 29 |
| 6258 | 6258 | 5448 5448 | RCA 29 |
| 6527 | 6527 | 5680 5680 | RCA 29 |
| 6656 | 6656 | 5793 5793 | RCA 29 |
| 6721 | 6721 | 5855 5855 | RCA 29 |
| 6731 | 6731 | 5863 5863 | RCA 29 |
| 6736 | 6736 | 5868 5868 | RCA 29 |
| 6739 | 6739 | 5870 5870 | RCA 29 |
| 6990 | 6990 | 6085 6085 | RCA 29 |
| 7001 | 7001 | 6096 6096 | RCA 29 |
| 7051 | 7051 | 6138 6138 | RCA 29 |
| 7126 | 7126 | 6203 6203 | RCA 29 |
| 7166 | 7166 | 6238 6238 | RCA 29 |
| 7175 | 7175 | 6246 6246 | RCA 29 |
| 7176 | 7176 | 6247 6247 | RCA 29 |
| 7204 | 7204 | 6269 6269 | RCA 29 |
| 7210 | 7210 | 6275 6275 | RCA 29 |
| 7260 | 7260 | 6313 6313 | RCA 29 |
| 7309 | 7309 | 6357 6357 | RCA 29 |
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) );