albums_labels
18 rows where label_id = 659
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1351 | 1351 | 1165 1165 | Deathwish 659 |
| 3902 | 3902 | 3410 3410 | Deathwish 659 |
| 8489 | 8489 | 7399 7399 | Deathwish 659 |
| 9453 | 9453 | 8266 8266 | Deathwish 659 |
| 9883 | 9883 | 8644 8644 | Deathwish 659 |
| 10277 | 10277 | 8992 8992 | Deathwish 659 |
| 10383 | 10383 | 9085 9085 | Deathwish 659 |
| 10524 | 10524 | 9211 9211 | Deathwish 659 |
| 11547 | 11547 | 10102 10102 | Deathwish 659 |
| 11752 | 11752 | 10287 10287 | Deathwish 659 |
| 11944 | 11944 | 10451 10451 | Deathwish 659 |
| 12398 | 12398 | 10871 10871 | Deathwish 659 |
| 12606 | 12606 | 11062 11062 | Deathwish 659 |
| 12683 | 12683 | 11135 11135 | Deathwish 659 |
| 12755 | 12755 | 11200 11200 | Deathwish 659 |
| 13136 | 13136 | 11548 11548 | Deathwish 659 |
| 17889 | 17889 | 15822 15822 | Deathwish 659 |
| 30423 | 30423 | 27414 27414 | Deathwish 659 |
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) );