albums_labels
152 rows where label_id = 3
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 3 | 3 | 3 3 | XL 3 |
| 295 | 295 | 254 254 | XL 3 |
| 372 | 372 | 317 317 | XL 3 |
| 808 | 808 | 682 682 | XL 3 |
| 814 | 814 | 688 688 | XL 3 |
| 939 | 939 | 800 800 | XL 3 |
| 1305 | 1305 | 1120 1120 | XL 3 |
| 1306 | 1306 | 1121 1121 | XL 3 |
| 1307 | 1307 | 1122 1122 | XL 3 |
| 1308 | 1308 | 1123 1123 | XL 3 |
| 1401 | 1401 | 1210 1210 | XL 3 |
| 1491 | 1491 | 1291 1291 | XL 3 |
| 1673 | 1673 | 1456 1456 | XL 3 |
| 1983 | 1983 | 1732 1732 | XL 3 |
| 2085 | 2085 | 1815 1815 | XL 3 |
| 2290 | 2290 | 1993 1993 | XL 3 |
| 2580 | 2580 | 2249 2249 | XL 3 |
| 2736 | 2736 | 2389 2389 | XL 3 |
| 3072 | 3072 | 2689 2689 | XL 3 |
| 3381 | 3381 | 2955 2955 | XL 3 |
| 3400 | 3400 | 2973 2973 | XL 3 |
| 3445 | 3445 | 3011 3011 | XL 3 |
| 3568 | 3568 | 3111 3111 | XL 3 |
| 3639 | 3639 | 3173 3173 | XL 3 |
| 4457 | 4457 | 3890 3890 | XL 3 |
| 4539 | 4539 | 3963 3963 | XL 3 |
| 5240 | 5240 | 4572 4572 | XL 3 |
| 5383 | 5383 | 4688 4688 | XL 3 |
| 5555 | 5555 | 4835 4835 | XL 3 |
| 5686 | 5686 | 4949 4949 | XL 3 |
| 5937 | 5937 | 5177 5177 | XL 3 |
| 6165 | 6165 | 5363 5363 | XL 3 |
| 6358 | 6358 | 5540 5540 | XL 3 |
| 6455 | 6455 | 5616 5616 | XL 3 |
| 6947 | 6947 | 6046 6046 | XL 3 |
| 6985 | 6985 | 6080 6080 | XL 3 |
| 7130 | 7130 | 6207 6207 | XL 3 |
| 7416 | 7416 | 6450 6450 | XL 3 |
| 7522 | 7522 | 6547 6547 | XL 3 |
| 7720 | 7720 | 6718 6718 | XL 3 |
| 7745 | 7745 | 6741 6741 | XL 3 |
| 8006 | 8006 | 6969 6969 | XL 3 |
| 8424 | 8424 | 7338 7338 | XL 3 |
| 8868 | 8868 | 7739 7739 | XL 3 |
| 9097 | 9097 | 7954 7954 | XL 3 |
| 9105 | 9105 | 7962 7962 | XL 3 |
| 9378 | 9378 | 8198 8198 | XL 3 |
| 9681 | 9681 | 8467 8467 | XL 3 |
| 9746 | 9746 | 8528 8528 | XL 3 |
| 9784 | 9784 | 8562 8562 | XL 3 |
| 9803 | 9803 | 8575 8575 | XL 3 |
| 9895 | 9895 | 8655 8655 | XL 3 |
| 9896 | 9896 | 8656 8656 | XL 3 |
| 10276 | 10276 | 8991 8991 | XL 3 |
| 10507 | 10507 | 9194 9194 | XL 3 |
| 10657 | 10657 | 9327 9327 | XL 3 |
| 10854 | 10854 | 9501 9501 | XL 3 |
| 11648 | 11648 | 10196 10196 | XL 3 |
| 11929 | 11929 | 10439 10439 | XL 3 |
| 12014 | 12014 | 10516 10516 | XL 3 |
| 12137 | 12137 | 10628 10628 | XL 3 |
| 12772 | 12772 | 11215 11215 | XL 3 |
| 12825 | 12825 | 11263 11263 | XL 3 |
| 13023 | 13023 | 11441 11441 | XL 3 |
| 13113 | 13113 | 11526 11526 | XL 3 |
| 13247 | 13247 | 11652 11652 | XL 3 |
| 13550 | 13550 | 11933 11933 | XL 3 |
| 13697 | 13697 | 12066 12066 | XL 3 |
| 13850 | 13850 | 12206 12206 | XL 3 |
| 13980 | 13980 | 12321 12321 | XL 3 |
| 14470 | 14470 | 12781 12781 | XL 3 |
| 14530 | 14530 | 12836 12836 | XL 3 |
| 14778 | 14778 | 13051 13051 | XL 3 |
| 15257 | 15257 | 13478 13478 | XL 3 |
| 15407 | 15407 | 13614 13614 | XL 3 |
| 15706 | 15706 | 13865 13865 | XL 3 |
| 15932 | 15932 | 14066 14066 | XL 3 |
| 15996 | 15996 | 14121 14121 | XL 3 |
| 16306 | 16306 | 14402 14402 | XL 3 |
| 16318 | 16318 | 14413 14413 | XL 3 |
| 16515 | 16515 | 14585 14585 | XL 3 |
| 17246 | 17246 | 15242 15242 | XL 3 |
| 17286 | 17286 | 15277 15277 | XL 3 |
| 17514 | 17514 | 15477 15477 | XL 3 |
| 17612 | 17612 | 15560 15560 | XL 3 |
| 17668 | 17668 | 15615 15615 | XL 3 |
| 17730 | 17730 | 15672 15672 | XL 3 |
| 17801 | 17801 | 15738 15738 | XL 3 |
| 17852 | 17852 | 15787 15787 | XL 3 |
| 18014 | 18014 | 15939 15939 | XL 3 |
| 18078 | 18078 | 16001 16001 | XL 3 |
| 18132 | 18132 | 16051 16051 | XL 3 |
| 18393 | 18393 | 16297 16297 | XL 3 |
| 18419 | 18419 | 16323 16323 | XL 3 |
| 18459 | 18459 | 16359 16359 | XL 3 |
| 18700 | 18700 | 16581 16581 | XL 3 |
| 18705 | 18705 | 16586 16586 | XL 3 |
| 18903 | 18903 | 16758 16758 | XL 3 |
| 19121 | 19121 | 16974 16974 | XL 3 |
| 19192 | 19192 | 17045 17045 | XL 3 |
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) );