albums_labels
35 rows where label_id = 97
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 111 | 111 | 98 98 | Mercury 97 |
| 711 | 711 | 600 600 | Mercury 97 |
| 900 | 900 | 770 770 | Mercury 97 |
| 1421 | 1421 | 1229 1229 | Mercury 97 |
| 2418 | 2418 | 2106 2106 | Mercury 97 |
| 2588 | 2588 | 2256 2256 | Mercury 97 |
| 5379 | 5379 | 4684 4684 | Mercury 97 |
| 5426 | 5426 | 4727 4727 | Mercury 97 |
| 5428 | 5428 | 4728 4728 | Mercury 97 |
| 7169 | 7169 | 6241 6241 | Mercury 97 |
| 8148 | 8148 | 7098 7098 | Mercury 97 |
| 9960 | 9960 | 8709 8709 | Mercury 97 |
| 9962 | 9962 | 8710 8710 | Mercury 97 |
| 11146 | 11146 | 9754 9754 | Mercury 97 |
| 13067 | 13067 | 11482 11482 | Mercury 97 |
| 13376 | 13376 | 11771 11771 | Mercury 97 |
| 13538 | 13538 | 11922 11922 | Mercury 97 |
| 14323 | 14323 | 12646 12646 | Mercury 97 |
| 15902 | 15902 | 14040 14040 | Mercury 97 |
| 16239 | 16239 | 14339 14339 | Mercury 97 |
| 17421 | 17421 | 15391 15391 | Mercury 97 |
| 18041 | 18041 | 15966 15966 | Mercury 97 |
| 18520 | 18520 | 16416 16416 | Mercury 97 |
| 19437 | 19437 | 17288 17288 | Mercury 97 |
| 19477 | 19477 | 17328 17328 | Mercury 97 |
| 20046 | 20046 | 17865 17865 | Mercury 97 |
| 21767 | 21767 | 19409 19409 | Mercury 97 |
| 23957 | 23957 | 21445 21445 | Mercury 97 |
| 26487 | 26487 | 23857 23857 | Mercury 97 |
| 28794 | 28794 | 25991 25991 | Mercury 97 |
| 29036 | 29036 | 26203 26203 | Mercury 97 |
| 29336 | 29336 | 26458 26458 | Mercury 97 |
| 29484 | 29484 | 26582 26582 | Mercury 97 |
| 29813 | 29813 | 26867 26867 | Mercury 97 |
| 30211 | 30211 | 27224 27224 | Mercury 97 |
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) );