albums_labels
6 rows where label_id = 4508
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 24390 | 24390 | 21852 21852 | Konkurrent 4508 |
| 25568 | 25568 | 22975 22975 | Konkurrent 4508 |
| 25916 | 25916 | 23313 23313 | Konkurrent 4508 |
| 27368 | 27368 | 24680 24680 | Konkurrent 4508 |
| 28328 | 28328 | 25567 25567 | Konkurrent 4508 |
| 29066 | 29066 | 26226 26226 | Konkurrent 4508 |
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) );