albums_labels
13 rows where label_id = 1560
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4810 | 4810 | 4201 4201 | Accidental 1560 |
| 10962 | 10962 | 9597 9597 | Accidental 1560 |
| 11666 | 11666 | 10212 10212 | Accidental 1560 |
| 13068 | 13068 | 11483 11483 | Accidental 1560 |
| 13756 | 13756 | 12120 12120 | Accidental 1560 |
| 15384 | 15384 | 13593 13593 | Accidental 1560 |
| 16874 | 16874 | 14906 14906 | Accidental 1560 |
| 17486 | 17486 | 15451 15451 | Accidental 1560 |
| 23803 | 23803 | 21299 21299 | Accidental 1560 |
| 24004 | 24004 | 21491 21491 | Accidental 1560 |
| 24790 | 24790 | 22227 22227 | Accidental 1560 |
| 25255 | 25255 | 22681 22681 | Accidental 1560 |
| 26232 | 26232 | 23613 23613 | Accidental 1560 |
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) );