albums_labels
7 rows where label_id = 1399
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4012 | 4012 | 3510 3510 | Factory 1399 |
| 11216 | 11216 | 9811 9811 | Factory 1399 |
| 20736 | 20736 | 18475 18475 | Factory 1399 |
| 20737 | 20737 | 18476 18476 | Factory 1399 |
| 20738 | 20738 | 18477 18477 | Factory 1399 |
| 23713 | 23713 | 21213 21213 | Factory 1399 |
| 26228 | 26228 | 23609 23609 | Factory 1399 |
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) );