albums_labels
16 rows where label_id = 153
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 186 | 186 | 162 162 | Griselda 153 |
| 255 | 255 | 220 220 | Griselda 153 |
| 586 | 586 | 492 492 | Griselda 153 |
| 1016 | 1016 | 869 869 | Griselda 153 |
| 1526 | 1526 | 1323 1323 | Griselda 153 |
| 1528 | 1528 | 1324 1324 | Griselda 153 |
| 1951 | 1951 | 1704 1704 | Griselda 153 |
| 2087 | 2087 | 1817 1817 | Griselda 153 |
| 2417 | 2417 | 2105 2105 | Griselda 153 |
| 2644 | 2644 | 2306 2306 | Griselda 153 |
| 2765 | 2765 | 2409 2409 | Griselda 153 |
| 2796 | 2796 | 2437 2437 | Griselda 153 |
| 2905 | 2905 | 2534 2534 | Griselda 153 |
| 3347 | 3347 | 2924 2924 | Griselda 153 |
| 5838 | 5838 | 5088 5088 | Griselda 153 |
| 30049 | 30049 | 27075 27075 | Griselda 153 |
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) );