albums_labels
13 rows where label_id = 2223
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8189 | 8189 | 7137 7137 | A&M 2223 |
| 8464 | 8464 | 7376 7376 | A&M 2223 |
| 15421 | 15421 | 13624 13624 | A&M 2223 |
| 16161 | 16161 | 14268 14268 | A&M 2223 |
| 16373 | 16373 | 14458 14458 | A&M 2223 |
| 16822 | 16822 | 14856 14856 | A&M 2223 |
| 18482 | 18482 | 16380 16380 | A&M 2223 |
| 18861 | 18861 | 16722 16722 | A&M 2223 |
| 18943 | 18943 | 16796 16796 | A&M 2223 |
| 20653 | 20653 | 18401 18401 | A&M 2223 |
| 25528 | 25528 | 22940 22940 | A&M 2223 |
| 27891 | 27891 | 25166 25166 | A&M 2223 |
| 29623 | 29623 | 26703 26703 | A&M 2223 |
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) );