albums_labels
21 rows where label_id = 3710
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 18930 | 18930 | 16784 16784 | Hush 3710 |
| 21182 | 21182 | 18882 18882 | Hush 3710 |
| 21497 | 21497 | 19162 19162 | Hush 3710 |
| 21980 | 21980 | 19605 19605 | Hush 3710 |
| 22744 | 22744 | 20302 20302 | Hush 3710 |
| 22868 | 22868 | 20418 20418 | Hush 3710 |
| 23272 | 23272 | 20800 20800 | Hush 3710 |
| 24611 | 24611 | 22059 22059 | Hush 3710 |
| 24786 | 24786 | 22223 22223 | Hush 3710 |
| 25408 | 25408 | 22827 22827 | Hush 3710 |
| 25625 | 25625 | 23032 23032 | Hush 3710 |
| 26348 | 26348 | 23724 23724 | Hush 3710 |
| 26524 | 26524 | 23894 23894 | Hush 3710 |
| 26711 | 26711 | 24074 24074 | Hush 3710 |
| 27009 | 27009 | 24351 24351 | Hush 3710 |
| 27603 | 27603 | 24900 24900 | Hush 3710 |
| 27668 | 27668 | 24961 24961 | Hush 3710 |
| 27850 | 27850 | 25128 25128 | Hush 3710 |
| 27964 | 27964 | 25235 25235 | Hush 3710 |
| 27979 | 27979 | 25249 25249 | Hush 3710 |
| 28077 | 28077 | 25338 25338 | Hush 3710 |
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) );