albums_labels
25 rows where label_id = 433
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 743 | 743 | 629 629 | Fiction 433 |
| 915 | 915 | 780 780 | Fiction 433 |
| 1183 | 1183 | 1018 1018 | Fiction 433 |
| 3612 | 3612 | 3150 3150 | Fiction 433 |
| 3749 | 3749 | 3270 3270 | Fiction 433 |
| 8633 | 8633 | 7528 7528 | Fiction 433 |
| 9788 | 9788 | 8564 8564 | Fiction 433 |
| 12147 | 12147 | 10638 10638 | Fiction 433 |
| 13892 | 13892 | 12244 12244 | Fiction 433 |
| 14203 | 14203 | 12528 12528 | Fiction 433 |
| 14462 | 14462 | 12773 12773 | Fiction 433 |
| 14980 | 14980 | 13227 13227 | Fiction 433 |
| 15339 | 15339 | 13550 13550 | Fiction 433 |
| 16219 | 16219 | 14321 14321 | Fiction 433 |
| 16453 | 16453 | 14527 14527 | Fiction 433 |
| 16777 | 16777 | 14815 14815 | Fiction 433 |
| 17408 | 17408 | 15380 15380 | Fiction 433 |
| 17409 | 17409 | 15381 15381 | Fiction 433 |
| 18936 | 18936 | 16789 16789 | Fiction 433 |
| 19922 | 19922 | 17754 17754 | Fiction 433 |
| 20099 | 20099 | 17908 17908 | Fiction 433 |
| 20928 | 20928 | 18647 18647 | Fiction 433 |
| 21118 | 21118 | 18823 18823 | Fiction 433 |
| 21212 | 21212 | 18906 18906 | Fiction 433 |
| 29831 | 29831 | 26882 26882 | Fiction 433 |
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) );