albums_labels
16 rows where label_id = 2274
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8484 | 8484 | 7394 7394 | VHF 2274 |
| 8485 | 8485 | 7395 7395 | VHF 2274 |
| 8486 | 8486 | 7396 7396 | VHF 2274 |
| 15740 | 15740 | 13897 13897 | VHF 2274 |
| 19801 | 19801 | 17643 17643 | VHF 2274 |
| 19973 | 19973 | 17802 17802 | VHF 2274 |
| 21019 | 21019 | 18730 18730 | VHF 2274 |
| 23227 | 23227 | 20757 20757 | VHF 2274 |
| 23449 | 23449 | 20967 20967 | VHF 2274 |
| 25788 | 25788 | 23192 23192 | VHF 2274 |
| 26934 | 26934 | 24282 24282 | VHF 2274 |
| 26975 | 26975 | 24320 24320 | VHF 2274 |
| 27428 | 27428 | 24736 24736 | VHF 2274 |
| 27880 | 27880 | 25155 25155 | VHF 2274 |
| 27885 | 27885 | 25160 25160 | VHF 2274 |
| 28118 | 28118 | 25375 25375 | VHF 2274 |
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) );