albums_labels
10 rows where label_id = 2809
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 12028 | 12028 | 10529 10529 | Park the Van 2809 |
| 16163 | 16163 | 14270 14270 | Park the Van 2809 |
| 19433 | 19433 | 17284 17284 | Park the Van 2809 |
| 19701 | 19701 | 17547 17547 | Park the Van 2809 |
| 20607 | 20607 | 18361 18361 | Park the Van 2809 |
| 21013 | 21013 | 18724 18724 | Park the Van 2809 |
| 21522 | 21522 | 19188 19188 | Park the Van 2809 |
| 21954 | 21954 | 19580 19580 | Park the Van 2809 |
| 22254 | 22254 | 19859 19859 | Park the Van 2809 |
| 22286 | 22286 | 19885 19885 | Park the Van 2809 |
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) );