albums_labels
6 rows where label_id = 1690
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 5364 | 5364 | 4670 4670 | Equal Vision 1690 |
| 13288 | 13288 | 11693 11693 | Equal Vision 1690 |
| 18396 | 18396 | 16300 16300 | Equal Vision 1690 |
| 23994 | 23994 | 21481 21481 | Equal Vision 1690 |
| 27452 | 27452 | 24758 24758 | Equal Vision 1690 |
| 27506 | 27506 | 24810 24810 | Equal Vision 1690 |
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) );