albums_labels
39 rows where label_id = 222
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 329 | 329 | 282 282 | Big Dada 222 |
| 676 | 676 | 568 568 | Big Dada 222 |
| 2118 | 2118 | 1843 1843 | Big Dada 222 |
| 5907 | 5907 | 5150 5150 | Big Dada 222 |
| 6651 | 6651 | 5788 5788 | Big Dada 222 |
| 6652 | 6652 | 5789 5789 | Big Dada 222 |
| 6844 | 6844 | 5966 5966 | Big Dada 222 |
| 7128 | 7128 | 6205 6205 | Big Dada 222 |
| 10666 | 10666 | 9336 9336 | Big Dada 222 |
| 11085 | 11085 | 9700 9700 | Big Dada 222 |
| 14012 | 14012 | 12348 12348 | Big Dada 222 |
| 15090 | 15090 | 13325 13325 | Big Dada 222 |
| 15779 | 15779 | 13929 13929 | Big Dada 222 |
| 16786 | 16786 | 14824 14824 | Big Dada 222 |
| 17384 | 17384 | 15358 15358 | Big Dada 222 |
| 18136 | 18136 | 16055 16055 | Big Dada 222 |
| 18350 | 18350 | 16256 16256 | Big Dada 222 |
| 18738 | 18738 | 16619 16619 | Big Dada 222 |
| 19083 | 19083 | 16936 16936 | Big Dada 222 |
| 19568 | 19568 | 17415 17415 | Big Dada 222 |
| 19744 | 19744 | 17589 17589 | Big Dada 222 |
| 20691 | 20691 | 18436 18436 | Big Dada 222 |
| 21233 | 21233 | 18925 18925 | Big Dada 222 |
| 21523 | 21523 | 19189 19189 | Big Dada 222 |
| 22772 | 22772 | 20330 20330 | Big Dada 222 |
| 24063 | 24063 | 21548 21548 | Big Dada 222 |
| 24308 | 24308 | 21777 21777 | Big Dada 222 |
| 24651 | 24651 | 22097 22097 | Big Dada 222 |
| 25152 | 25152 | 22580 22580 | Big Dada 222 |
| 26372 | 26372 | 23748 23748 | Big Dada 222 |
| 26810 | 26810 | 24168 24168 | Big Dada 222 |
| 26930 | 26930 | 24278 24278 | Big Dada 222 |
| 27420 | 27420 | 24729 24729 | Big Dada 222 |
| 27571 | 27571 | 24870 24870 | Big Dada 222 |
| 28024 | 28024 | 25290 25290 | Big Dada 222 |
| 29117 | 29117 | 26266 26266 | Big Dada 222 |
| 29431 | 29431 | 26534 26534 | Big Dada 222 |
| 29942 | 29942 | 26978 26978 | Big Dada 222 |
| 30150 | 30150 | 27170 27170 | Big Dada 222 |
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) );