albums_labels
12 rows where label_id = 3451
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 16899 | 16899 | 14928 14928 | Holy Mountain 3451 |
| 18794 | 18794 | 16663 16663 | Holy Mountain 3451 |
| 19634 | 19634 | 17481 17481 | Holy Mountain 3451 |
| 20804 | 20804 | 18534 18534 | Holy Mountain 3451 |
| 21003 | 21003 | 18717 18717 | Holy Mountain 3451 |
| 21827 | 21827 | 19464 19464 | Holy Mountain 3451 |
| 22629 | 22629 | 20199 20199 | Holy Mountain 3451 |
| 23130 | 23130 | 20661 20661 | Holy Mountain 3451 |
| 23959 | 23959 | 21447 21447 | Holy Mountain 3451 |
| 25266 | 25266 | 22691 22691 | Holy Mountain 3451 |
| 25907 | 25907 | 23304 23304 | Holy Mountain 3451 |
| 27791 | 27791 | 25075 25075 | Holy Mountain 3451 |
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) );