albums_labels
23 rows where label_id = 360
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 596 | 596 | 500 500 | Thirty Tigers 360 |
| 761 | 761 | 644 644 | Thirty Tigers 360 |
| 965 | 965 | 823 823 | Thirty Tigers 360 |
| 1130 | 1130 | 971 971 | Thirty Tigers 360 |
| 2039 | 2039 | 1776 1776 | Thirty Tigers 360 |
| 2254 | 2254 | 1960 1960 | Thirty Tigers 360 |
| 2295 | 2295 | 1997 1997 | Thirty Tigers 360 |
| 2637 | 2637 | 2299 2299 | Thirty Tigers 360 |
| 2935 | 2935 | 2562 2562 | Thirty Tigers 360 |
| 3316 | 3316 | 2898 2898 | Thirty Tigers 360 |
| 4722 | 4722 | 4121 4121 | Thirty Tigers 360 |
| 5448 | 5448 | 4744 4744 | Thirty Tigers 360 |
| 8651 | 8651 | 7542 7542 | Thirty Tigers 360 |
| 9493 | 9493 | 8301 8301 | Thirty Tigers 360 |
| 10045 | 10045 | 8786 8786 | Thirty Tigers 360 |
| 10243 | 10243 | 8962 8962 | Thirty Tigers 360 |
| 13021 | 13021 | 11440 11440 | Thirty Tigers 360 |
| 14766 | 14766 | 13040 13040 | Thirty Tigers 360 |
| 29316 | 29316 | 26439 26439 | Thirty Tigers 360 |
| 29440 | 29440 | 26541 26541 | Thirty Tigers 360 |
| 29655 | 29655 | 26731 26731 | Thirty Tigers 360 |
| 29740 | 29740 | 26803 26803 | Thirty Tigers 360 |
| 29945 | 29945 | 26981 26981 | Thirty Tigers 360 |
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) );