albums_labels
14 rows where label_id = 2498
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9860 | 9860 | 8624 8624 | Up 2498 |
| 11205 | 11205 | 9804 9804 | Up 2498 |
| 11208 | 11208 | 9805 9805 | Up 2498 |
| 22465 | 22465 | 20048 20048 | Up 2498 |
| 25924 | 25924 | 23321 23321 | Up 2498 |
| 27091 | 27091 | 24422 24422 | Up 2498 |
| 27372 | 27372 | 24684 24684 | Up 2498 |
| 28428 | 28428 | 25661 25661 | Up 2498 |
| 28642 | 28642 | 25854 25854 | Up 2498 |
| 28681 | 28681 | 25886 25886 | Up 2498 |
| 28881 | 28881 | 26070 26070 | Up 2498 |
| 28905 | 28905 | 26091 26091 | Up 2498 |
| 28981 | 28981 | 26158 26158 | Up 2498 |
| 28991 | 28991 | 26165 26165 | Up 2498 |
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) );