albums_labels

10 rows where label_id = 1104

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2846 2846 2482 2482 Sub Rosa 1104
7646 7646 6657 6657 Sub Rosa 1104
8808 8808 7688 7688 Sub Rosa 1104
15533 15533 13724 13724 Sub Rosa 1104
16578 16578 14641 14641 Sub Rosa 1104
21475 21475 19146 19146 Sub Rosa 1104
21872 21872 19503 19503 Sub Rosa 1104
24662 24662 22108 22108 Sub Rosa 1104
26163 26163 23546 23546 Sub Rosa 1104
26965 26965 24310 24310 Sub Rosa 1104

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);