albums_labels
11 rows where label_id = 391
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 646 | 646 | 542 542 | Megaforce 391 |
| 4897 | 4897 | 4280 4280 | Megaforce 391 |
| 10787 | 10787 | 9441 9441 | Megaforce 391 |
| 13331 | 13331 | 11731 11731 | Megaforce 391 |
| 13836 | 13836 | 12192 12192 | Megaforce 391 |
| 16096 | 16096 | 14212 14212 | Megaforce 391 |
| 18661 | 18661 | 16544 16544 | Megaforce 391 |
| 20239 | 20239 | 18023 18023 | Megaforce 391 |
| 21210 | 21210 | 18905 18905 | Megaforce 391 |
| 22787 | 22787 | 20343 20343 | Megaforce 391 |
| 30433 | 30433 | 27424 27424 | Megaforce 391 |
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) );