albums_labels
12 rows where label_id = 4134
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 21376 | 21376 | 19058 19058 | Hefty 4134 |
| 21584 | 21584 | 19244 19244 | Hefty 4134 |
| 21777 | 21777 | 19418 19418 | Hefty 4134 |
| 22531 | 22531 | 20107 20107 | Hefty 4134 |
| 23063 | 23063 | 20600 20600 | Hefty 4134 |
| 24479 | 24479 | 21938 21938 | Hefty 4134 |
| 25612 | 25612 | 23019 23019 | Hefty 4134 |
| 26887 | 26887 | 24239 24239 | Hefty 4134 |
| 28158 | 28158 | 25408 25408 | Hefty 4134 |
| 28205 | 28205 | 25452 25452 | Hefty 4134 |
| 28527 | 28527 | 25750 25750 | Hefty 4134 |
| 28770 | 28770 | 25969 25969 | Hefty 4134 |
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) );