albums_labels
21 rows where label_id = 3503
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 17265 | 17265 | 15260 15260 | Koch 3503 |
| 19755 | 19755 | 17600 17600 | Koch 3503 |
| 19816 | 19816 | 17658 17658 | Koch 3503 |
| 20150 | 20150 | 17951 17951 | Koch 3503 |
| 20520 | 20520 | 18281 18281 | Koch 3503 |
| 20551 | 20551 | 18310 18310 | Koch 3503 |
| 21205 | 21205 | 18901 18901 | Koch 3503 |
| 21479 | 21479 | 19150 19150 | Koch 3503 |
| 21789 | 21789 | 19429 19429 | Koch 3503 |
| 22348 | 22348 | 19943 19943 | Koch 3503 |
| 22375 | 22375 | 19967 19967 | Koch 3503 |
| 22551 | 22551 | 20125 20125 | Koch 3503 |
| 22646 | 22646 | 20214 20214 | Koch 3503 |
| 22885 | 22885 | 20432 20432 | Koch 3503 |
| 23797 | 23797 | 21293 21293 | Koch 3503 |
| 24051 | 24051 | 21537 21537 | Koch 3503 |
| 24315 | 24315 | 21784 21784 | Koch 3503 |
| 25280 | 25280 | 22705 22705 | Koch 3503 |
| 26580 | 26580 | 23947 23947 | Koch 3503 |
| 27320 | 27320 | 24634 24634 | Koch 3503 |
| 30064 | 30064 | 27087 27087 | Koch 3503 |
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) );