albums_labels
26 rows where label_id = 357
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 587 | 587 | 493 493 | Heavenly 357 |
| 887 | 887 | 759 759 | Heavenly 357 |
| 1591 | 1591 | 1382 1382 | Heavenly 357 |
| 4558 | 4558 | 3981 3981 | Heavenly 357 |
| 7462 | 7462 | 6492 6492 | Heavenly 357 |
| 7628 | 7628 | 6643 6643 | Heavenly 357 |
| 10124 | 10124 | 8859 8859 | Heavenly 357 |
| 10246 | 10246 | 8964 8964 | Heavenly 357 |
| 11071 | 11071 | 9689 9689 | Heavenly 357 |
| 12263 | 12263 | 10743 10743 | Heavenly 357 |
| 13804 | 13804 | 12161 12161 | Heavenly 357 |
| 13805 | 13805 | 12162 12162 | Heavenly 357 |
| 16663 | 16663 | 14710 14710 | Heavenly 357 |
| 16665 | 16665 | 14711 14711 | Heavenly 357 |
| 16820 | 16820 | 14854 14854 | Heavenly 357 |
| 17051 | 17051 | 15067 15067 | Heavenly 357 |
| 17255 | 17255 | 15251 15251 | Heavenly 357 |
| 17256 | 17256 | 15252 15252 | Heavenly 357 |
| 18217 | 18217 | 16129 16129 | Heavenly 357 |
| 18218 | 18218 | 16130 16130 | Heavenly 357 |
| 18534 | 18534 | 16429 16429 | Heavenly 357 |
| 18535 | 18535 | 16430 16430 | Heavenly 357 |
| 18805 | 18805 | 16673 16673 | Heavenly 357 |
| 20858 | 20858 | 18583 18583 | Heavenly 357 |
| 24075 | 24075 | 21558 21558 | Heavenly 357 |
| 29368 | 29368 | 26482 26482 | Heavenly 357 |
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) );