albums_labels
11 rows where label_id = 658
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1349 | 1349 | 1163 1163 | Priority 658 |
| 7575 | 7575 | 6593 6593 | Priority 658 |
| 7609 | 7609 | 6625 6625 | Priority 658 |
| 8242 | 8242 | 7181 7181 | Priority 658 |
| 16123 | 16123 | 14236 14236 | Priority 658 |
| 19444 | 19444 | 17295 17295 | Priority 658 |
| 23631 | 23631 | 21138 21138 | Priority 658 |
| 25570 | 25570 | 22977 22977 | Priority 658 |
| 26038 | 26038 | 23428 23428 | Priority 658 |
| 26077 | 26077 | 23465 23465 | Priority 658 |
| 26078 | 26078 | 23466 23466 | Priority 658 |
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) );