albums_labels
12 rows where label_id = 422
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 720 | 720 | 607 607 | Memphis Industries 422 |
| 1817 | 1817 | 1591 1591 | Memphis Industries 422 |
| 2065 | 2065 | 1798 1798 | Memphis Industries 422 |
| 2335 | 2335 | 2031 2031 | Memphis Industries 422 |
| 3651 | 3651 | 3184 3184 | Memphis Industries 422 |
| 3724 | 3724 | 3246 3246 | Memphis Industries 422 |
| 4422 | 4422 | 3859 3859 | Memphis Industries 422 |
| 4771 | 4771 | 4166 4166 | Memphis Industries 422 |
| 5683 | 5683 | 4947 4947 | Memphis Industries 422 |
| 6530 | 6530 | 5683 5683 | Memphis Industries 422 |
| 6589 | 6589 | 5734 5734 | Memphis Industries 422 |
| 29191 | 29191 | 26331 26331 | Memphis Industries 422 |
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) );