albums_labels
16 rows where label_id = 1484
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4436 | 4436 | 3873 3873 | Graveface 1484 |
| 9994 | 9994 | 8741 8741 | Graveface 1484 |
| 11401 | 11401 | 9973 9973 | Graveface 1484 |
| 12437 | 12437 | 10908 10908 | Graveface 1484 |
| 12602 | 12602 | 11058 11058 | Graveface 1484 |
| 12948 | 12948 | 11373 11373 | Graveface 1484 |
| 12976 | 12976 | 11399 11399 | Graveface 1484 |
| 13320 | 13320 | 11721 11721 | Graveface 1484 |
| 13552 | 13552 | 11935 11935 | Graveface 1484 |
| 13996 | 13996 | 12335 12335 | Graveface 1484 |
| 15865 | 15865 | 14007 14007 | Graveface 1484 |
| 16794 | 16794 | 14831 14831 | Graveface 1484 |
| 17378 | 17378 | 15352 15352 | Graveface 1484 |
| 17723 | 17723 | 15666 15666 | Graveface 1484 |
| 18633 | 18633 | 16519 16519 | Graveface 1484 |
| 21347 | 21347 | 19030 19030 | Graveface 1484 |
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) );