albums_labels
6 rows where label_id = 4359
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 23053 | 23053 | 20590 20590 | Häpna 4359 |
| 23852 | 23852 | 21347 21347 | Häpna 4359 |
| 25672 | 25672 | 23078 23078 | Häpna 4359 |
| 26011 | 26011 | 23401 23401 | Häpna 4359 |
| 26465 | 26465 | 23835 23835 | Häpna 4359 |
| 28098 | 28098 | 25357 25357 | Häpna 4359 |
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) );