albums_labels
16 rows where label_id = 4262
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 22293 | 22293 | 19891 19891 | GSL 4262 |
| 22496 | 22496 | 20075 20075 | GSL 4262 |
| 23211 | 23211 | 20742 20742 | GSL 4262 |
| 23771 | 23771 | 21267 21267 | GSL 4262 |
| 23862 | 23862 | 21357 21357 | GSL 4262 |
| 25001 | 25001 | 22437 22437 | GSL 4262 |
| 25451 | 25451 | 22868 22868 | GSL 4262 |
| 25621 | 25621 | 23028 23028 | GSL 4262 |
| 25622 | 25622 | 23029 23029 | GSL 4262 |
| 25653 | 25653 | 23059 23059 | GSL 4262 |
| 25694 | 25694 | 23099 23099 | GSL 4262 |
| 26330 | 26330 | 23706 23706 | GSL 4262 |
| 26389 | 26389 | 23765 23765 | GSL 4262 |
| 26546 | 26546 | 23915 23915 | GSL 4262 |
| 26554 | 26554 | 23922 23922 | GSL 4262 |
| 28003 | 28003 | 25272 25272 | GSL 4262 |
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) );