albums_labels
8 rows where label_id = 2926
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 12728 | 12728 | 11175 11175 | Realworld 2926 |
| 17706 | 17706 | 15652 15652 | Realworld 2926 |
| 19149 | 19149 | 17002 17002 | Realworld 2926 |
| 20055 | 20055 | 17872 17872 | Realworld 2926 |
| 28526 | 28526 | 25749 25749 | Realworld 2926 |
| 28791 | 28791 | 25988 25988 | Realworld 2926 |
| 30189 | 30189 | 27205 27205 | Realworld 2926 |
| 30324 | 30324 | 27325 27325 | Realworld 2926 |
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) );