albums_labels
19 rows where label_id = 482
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 862 | 862 | 735 735 | New West 482 |
| 1642 | 1642 | 1427 1427 | New West 482 |
| 1693 | 1693 | 1474 1474 | New West 482 |
| 1799 | 1799 | 1571 1571 | New West 482 |
| 2390 | 2390 | 2080 2080 | New West 482 |
| 2438 | 2438 | 2124 2124 | New West 482 |
| 29269 | 29269 | 26397 26397 | New West 482 |
| 29425 | 29425 | 26529 26529 | New West 482 |
| 29510 | 29510 | 26607 26607 | New West 482 |
| 29692 | 29692 | 26763 26763 | New West 482 |
| 30153 | 30153 | 27173 27173 | New West 482 |
| 30154 | 30154 | 27174 27174 | New West 482 |
| 30155 | 30155 | 27175 27175 | New West 482 |
| 30156 | 30156 | 27176 27176 | New West 482 |
| 30157 | 30157 | 27177 27177 | New West 482 |
| 30158 | 30158 | 27178 27178 | New West 482 |
| 30159 | 30159 | 27179 27179 | New West 482 |
| 30160 | 30160 | 27180 27180 | New West 482 |
| 30322 | 30322 | 27323 27323 | New West 482 |
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) );