albums_labels
14 rows where label_id = 4113
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 21251 | 21251 | 18941 18941 | TVT 4113 |
| 22529 | 22529 | 20105 20105 | TVT 4113 |
| 23231 | 23231 | 20761 20761 | TVT 4113 |
| 23903 | 23903 | 21394 21394 | TVT 4113 |
| 24178 | 24178 | 21651 21651 | TVT 4113 |
| 26205 | 26205 | 23587 23587 | TVT 4113 |
| 28430 | 28430 | 25663 25663 | TVT 4113 |
| 28735 | 28735 | 25938 25938 | TVT 4113 |
| 28805 | 28805 | 26001 26001 | TVT 4113 |
| 28899 | 28899 | 26085 26085 | TVT 4113 |
| 29044 | 29044 | 26208 26208 | TVT 4113 |
| 29136 | 29136 | 26283 26283 | TVT 4113 |
| 29273 | 29273 | 26401 26401 | TVT 4113 |
| 29598 | 29598 | 26683 26683 | TVT 4113 |
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) );