albums_labels
25 rows where label_id = 91
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 105 | 105 | 93 93 | 20 Buck Spin 91 |
| 158 | 158 | 135 135 | 20 Buck Spin 91 |
| 1310 | 1310 | 1125 1125 | 20 Buck Spin 91 |
| 1622 | 1622 | 1409 1409 | 20 Buck Spin 91 |
| 3119 | 3119 | 2725 2725 | 20 Buck Spin 91 |
| 4368 | 4368 | 3813 3813 | 20 Buck Spin 91 |
| 4633 | 4633 | 4043 4043 | 20 Buck Spin 91 |
| 5004 | 5004 | 4371 4371 | 20 Buck Spin 91 |
| 5868 | 5868 | 5116 5116 | 20 Buck Spin 91 |
| 6989 | 6989 | 6084 6084 | 20 Buck Spin 91 |
| 8367 | 8367 | 7290 7290 | 20 Buck Spin 91 |
| 9407 | 9407 | 8224 8224 | 20 Buck Spin 91 |
| 9712 | 9712 | 8494 8494 | 20 Buck Spin 91 |
| 10450 | 10450 | 9145 9145 | 20 Buck Spin 91 |
| 10616 | 10616 | 9291 9291 | 20 Buck Spin 91 |
| 12430 | 12430 | 10901 10901 | 20 Buck Spin 91 |
| 12596 | 12596 | 11052 11052 | 20 Buck Spin 91 |
| 12925 | 12925 | 11353 11353 | 20 Buck Spin 91 |
| 12949 | 12949 | 11374 11374 | 20 Buck Spin 91 |
| 13284 | 13284 | 11689 11689 | 20 Buck Spin 91 |
| 14297 | 14297 | 12621 12621 | 20 Buck Spin 91 |
| 17718 | 17718 | 15661 15661 | 20 Buck Spin 91 |
| 29321 | 29321 | 26444 26444 | 20 Buck Spin 91 |
| 29322 | 29322 | 26445 26445 | 20 Buck Spin 91 |
| 29955 | 29955 | 26989 26989 | 20 Buck Spin 91 |
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) );