albums_labels
21 rows where label_id = 1328
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 3739 | 3739 | 3260 3260 | MCA 1328 |
| 5779 | 5779 | 5031 5031 | MCA 1328 |
| 6436 | 6436 | 5601 5601 | MCA 1328 |
| 6958 | 6958 | 6056 6056 | MCA 1328 |
| 6960 | 6960 | 6057 6057 | MCA 1328 |
| 8644 | 8644 | 7536 7536 | MCA 1328 |
| 26021 | 26021 | 23411 23411 | MCA 1328 |
| 26463 | 26463 | 23833 23833 | MCA 1328 |
| 26541 | 26541 | 23910 23910 | MCA 1328 |
| 26912 | 26912 | 24263 24263 | MCA 1328 |
| 26976 | 26976 | 24321 24321 | MCA 1328 |
| 27011 | 27011 | 24353 24353 | MCA 1328 |
| 27528 | 27528 | 24831 24831 | MCA 1328 |
| 27548 | 27548 | 24849 24849 | MCA 1328 |
| 27941 | 27941 | 25214 25214 | MCA 1328 |
| 28470 | 28470 | 25698 25698 | MCA 1328 |
| 28819 | 28819 | 26015 26015 | MCA 1328 |
| 28827 | 28827 | 26021 26021 | MCA 1328 |
| 28859 | 28859 | 26049 26049 | MCA 1328 |
| 28874 | 28874 | 26063 26063 | MCA 1328 |
| 29868 | 29868 | 26913 26913 | MCA 1328 |
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) );