albums_labels
26 rows where label_id = 13
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 18 | 18 | 17 17 | AWAL 13 |
| 311 | 311 | 269 269 | AWAL 13 |
| 399 | 399 | 340 340 | AWAL 13 |
| 997 | 997 | 851 851 | AWAL 13 |
| 2036 | 2036 | 1774 1774 | AWAL 13 |
| 2540 | 2540 | 2212 2212 | AWAL 13 |
| 2577 | 2577 | 2246 2246 | AWAL 13 |
| 2774 | 2774 | 2417 2417 | AWAL 13 |
| 2924 | 2924 | 2553 2553 | AWAL 13 |
| 3505 | 3505 | 3062 3062 | AWAL 13 |
| 3587 | 3587 | 3129 3129 | AWAL 13 |
| 4181 | 4181 | 3659 3659 | AWAL 13 |
| 4184 | 4184 | 3661 3661 | AWAL 13 |
| 4242 | 4242 | 3710 3710 | AWAL 13 |
| 4572 | 4572 | 3992 3992 | AWAL 13 |
| 4746 | 4746 | 4141 4141 | AWAL 13 |
| 4912 | 4912 | 4293 4293 | AWAL 13 |
| 5563 | 5563 | 4842 4842 | AWAL 13 |
| 7982 | 7982 | 6948 6948 | AWAL 13 |
| 17834 | 17834 | 15769 15769 | AWAL 13 |
| 29420 | 29420 | 26524 26524 | AWAL 13 |
| 29509 | 29509 | 26606 26606 | AWAL 13 |
| 29932 | 29932 | 26970 26970 | AWAL 13 |
| 29965 | 29965 | 26998 26998 | AWAL 13 |
| 30015 | 30015 | 27043 27043 | AWAL 13 |
| 30355 | 30355 | 27352 27352 | AWAL 13 |
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) );