albums_labels
14 rows where label_id = 1838
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 6173 | 6173 | 5370 5370 | Babygrande 1838 |
| 8137 | 8137 | 7087 7087 | Babygrande 1838 |
| 13873 | 13873 | 12226 12226 | Babygrande 1838 |
| 19593 | 19593 | 17440 17440 | Babygrande 1838 |
| 20489 | 20489 | 18252 18252 | Babygrande 1838 |
| 20907 | 20907 | 18627 18627 | Babygrande 1838 |
| 22109 | 22109 | 19726 19726 | Babygrande 1838 |
| 22647 | 22647 | 20214 20214 | Babygrande 1838 |
| 23498 | 23498 | 21012 21012 | Babygrande 1838 |
| 24897 | 24897 | 22333 22333 | Babygrande 1838 |
| 25084 | 25084 | 22516 22516 | Babygrande 1838 |
| 25308 | 25308 | 22731 22731 | Babygrande 1838 |
| 25935 | 25935 | 23332 23332 | Babygrande 1838 |
| 26209 | 26209 | 23591 23591 | Babygrande 1838 |
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) );