albums_labels
5 rows where label_id = 506
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 927 | 927 | 789 789 | Feel It 506 |
| 29260 | 29260 | 26390 26390 | Feel It 506 |
| 29649 | 29649 | 26726 26726 | Feel It 506 |
| 29743 | 29743 | 26805 26805 | Feel It 506 |
| 30241 | 30241 | 27251 27251 | Feel It 506 |
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) );