albums_labels
18 rows where label_id = 2337
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8855 | 8855 | 7730 7730 | Staubgold 2337 |
| 13237 | 13237 | 11643 11643 | Staubgold 2337 |
| 17597 | 17597 | 15547 15547 | Staubgold 2337 |
| 18667 | 18667 | 16550 16550 | Staubgold 2337 |
| 21893 | 21893 | 19523 19523 | Staubgold 2337 |
| 22704 | 22704 | 20265 20265 | Staubgold 2337 |
| 22831 | 22831 | 20384 20384 | Staubgold 2337 |
| 24129 | 24129 | 21607 21607 | Staubgold 2337 |
| 24210 | 24210 | 21682 21682 | Staubgold 2337 |
| 25405 | 25405 | 22824 22824 | Staubgold 2337 |
| 25456 | 25456 | 22873 22873 | Staubgold 2337 |
| 25490 | 25490 | 22905 22905 | Staubgold 2337 |
| 25684 | 25684 | 23089 23089 | Staubgold 2337 |
| 26363 | 26363 | 23739 23739 | Staubgold 2337 |
| 26367 | 26367 | 23743 23743 | Staubgold 2337 |
| 26762 | 26762 | 24123 24123 | Staubgold 2337 |
| 26963 | 26963 | 24308 24308 | Staubgold 2337 |
| 27148 | 27148 | 24476 24476 | Staubgold 2337 |
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) );