albums_labels
15 rows where label_id = 1174
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 3108 | 3108 | 2715 2715 | Secret City 1174 |
| 3755 | 3755 | 3276 3276 | Secret City 1174 |
| 9192 | 9192 | 8039 8039 | Secret City 1174 |
| 11849 | 11849 | 10368 10368 | Secret City 1174 |
| 14914 | 14914 | 13168 13168 | Secret City 1174 |
| 15735 | 15735 | 13893 13893 | Secret City 1174 |
| 16671 | 16671 | 14717 14717 | Secret City 1174 |
| 17458 | 17458 | 15423 15423 | Secret City 1174 |
| 17738 | 17738 | 15679 15679 | Secret City 1174 |
| 18675 | 18675 | 16558 16558 | Secret City 1174 |
| 19573 | 19573 | 17420 17420 | Secret City 1174 |
| 20253 | 20253 | 18035 18035 | Secret City 1174 |
| 20585 | 20585 | 18340 18340 | Secret City 1174 |
| 21300 | 21300 | 18987 18987 | Secret City 1174 |
| 29541 | 29541 | 26633 26633 | Secret City 1174 |
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) );