albums_labels
11 rows where label_id = 2369
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9049 | 9049 | 7905 7905 | Now Again 2369 |
| 9050 | 9050 | 7906 7906 | Now Again 2369 |
| 13300 | 13300 | 11704 11704 | Now Again 2369 |
| 15141 | 15141 | 13374 13374 | Now Again 2369 |
| 17008 | 17008 | 15028 15028 | Now Again 2369 |
| 17532 | 17532 | 15494 15494 | Now Again 2369 |
| 17776 | 17776 | 15714 15714 | Now Again 2369 |
| 19956 | 19956 | 17787 17787 | Now Again 2369 |
| 20608 | 20608 | 18362 18362 | Now Again 2369 |
| 21075 | 21075 | 18782 18782 | Now Again 2369 |
| 25805 | 25805 | 23209 23209 | Now Again 2369 |
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) );