albums_labels
12 rows where label_id = 2562
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 10308 | 10308 | 9020 9020 | Sincerely Yours 2562 |
| 11524 | 11524 | 10081 10081 | Sincerely Yours 2562 |
| 14394 | 14394 | 12713 12713 | Sincerely Yours 2562 |
| 16509 | 16509 | 14579 14579 | Sincerely Yours 2562 |
| 17153 | 17153 | 15161 15161 | Sincerely Yours 2562 |
| 17875 | 17875 | 15808 15808 | Sincerely Yours 2562 |
| 18171 | 18171 | 16086 16086 | Sincerely Yours 2562 |
| 18426 | 18426 | 16329 16329 | Sincerely Yours 2562 |
| 19804 | 19804 | 17646 17646 | Sincerely Yours 2562 |
| 20510 | 20510 | 18271 18271 | Sincerely Yours 2562 |
| 20775 | 20775 | 18508 18508 | Sincerely Yours 2562 |
| 21143 | 21143 | 18846 18846 | Sincerely Yours 2562 |
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) );