albums_labels
11 rows where label_id = 579
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1106 | 1106 | 950 950 | IRS 579 |
| 2635 | 2635 | 2298 2298 | IRS 579 |
| 4009 | 4009 | 3507 3507 | IRS 579 |
| 5135 | 5135 | 4491 4491 | IRS 579 |
| 15263 | 15263 | 13483 13483 | IRS 579 |
| 15739 | 15739 | 13896 13896 | IRS 579 |
| 17102 | 17102 | 15114 15114 | IRS 579 |
| 18483 | 18483 | 16380 16380 | IRS 579 |
| 19261 | 19261 | 17113 17113 | IRS 579 |
| 23419 | 23419 | 20937 20937 | IRS 579 |
| 24021 | 24021 | 21508 21508 | IRS 579 |
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) );