albums_labels
23 rows where label_id = 2574
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 10390 | 10390 | 9091 9091 | !K7 2574 |
| 11662 | 11662 | 10208 10208 | !K7 2574 |
| 12219 | 12219 | 10703 10703 | !K7 2574 |
| 12528 | 12528 | 10991 10991 | !K7 2574 |
| 13991 | 13991 | 12330 12330 | !K7 2574 |
| 14373 | 14373 | 12692 12692 | !K7 2574 |
| 14390 | 14390 | 12709 12709 | !K7 2574 |
| 15320 | 15320 | 13532 13532 | !K7 2574 |
| 15347 | 15347 | 13557 13557 | !K7 2574 |
| 15629 | 15629 | 13803 13803 | !K7 2574 |
| 15682 | 15682 | 13844 13844 | !K7 2574 |
| 16234 | 16234 | 14335 14335 | !K7 2574 |
| 16643 | 16643 | 14694 14694 | !K7 2574 |
| 16725 | 16725 | 14765 14765 | !K7 2574 |
| 16806 | 16806 | 14843 14843 | !K7 2574 |
| 17055 | 17055 | 15071 15071 | !K7 2574 |
| 17171 | 17171 | 15179 15179 | !K7 2574 |
| 17302 | 17302 | 15292 15292 | !K7 2574 |
| 17416 | 17416 | 15386 15386 | !K7 2574 |
| 17644 | 17644 | 15591 15591 | !K7 2574 |
| 17816 | 17816 | 15752 15752 | !K7 2574 |
| 17872 | 17872 | 15805 15805 | !K7 2574 |
| 18127 | 18127 | 16047 16047 | !K7 2574 |
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) );