albums_labels
26 rows where label_id = 2958
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 12984 | 12984 | 11407 11407 | ATP 2958 |
| 12997 | 12997 | 11419 11419 | ATP 2958 |
| 13215 | 13215 | 11622 11622 | ATP 2958 |
| 13730 | 13730 | 12094 12094 | ATP 2958 |
| 16811 | 16811 | 14847 14847 | ATP 2958 |
| 17148 | 17148 | 15157 15157 | ATP 2958 |
| 17655 | 17655 | 15602 15602 | ATP 2958 |
| 17819 | 17819 | 15755 15755 | ATP 2958 |
| 18076 | 18076 | 15999 15999 | ATP 2958 |
| 18548 | 18548 | 16442 16442 | ATP 2958 |
| 18905 | 18905 | 16760 16760 | ATP 2958 |
| 19516 | 19516 | 17366 17366 | ATP 2958 |
| 20243 | 20243 | 18026 18026 | ATP 2958 |
| 21400 | 21400 | 19081 19081 | ATP 2958 |
| 22019 | 22019 | 19642 19642 | ATP 2958 |
| 22593 | 22593 | 20165 20165 | ATP 2958 |
| 23202 | 23202 | 20733 20733 | ATP 2958 |
| 23302 | 23302 | 20829 20829 | ATP 2958 |
| 23322 | 23322 | 20849 20849 | ATP 2958 |
| 23789 | 23789 | 21285 21285 | ATP 2958 |
| 23880 | 23880 | 21373 21373 | ATP 2958 |
| 25777 | 25777 | 23181 23181 | ATP 2958 |
| 26261 | 26261 | 23641 23641 | ATP 2958 |
| 26318 | 26318 | 23694 23694 | ATP 2958 |
| 27552 | 27552 | 24853 24853 | ATP 2958 |
| 27921 | 27921 | 25195 25195 | ATP 2958 |
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) );