albums_labels
11 rows where label_id = 1737
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 5668 | 5668 | 4933 4933 | Subliminal Sounds 1737 |
| 12134 | 12134 | 10625 10625 | Subliminal Sounds 1737 |
| 14397 | 14397 | 12716 12716 | Subliminal Sounds 1737 |
| 16883 | 16883 | 14914 14914 | Subliminal Sounds 1737 |
| 17716 | 17716 | 15659 15659 | Subliminal Sounds 1737 |
| 19465 | 19465 | 17316 17316 | Subliminal Sounds 1737 |
| 21353 | 21353 | 19035 19035 | Subliminal Sounds 1737 |
| 24094 | 24094 | 21576 21576 | Subliminal Sounds 1737 |
| 24957 | 24957 | 22393 22393 | Subliminal Sounds 1737 |
| 25509 | 25509 | 22922 22922 | Subliminal Sounds 1737 |
| 28013 | 28013 | 25282 25282 | Subliminal Sounds 1737 |
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) );