albums_labels

13 rows where label_id = 2491

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9817 9817 8587 8587 Cherrytree 2491
10193 10193 8918 8918 Cherrytree 2491
11837 11837 10358 10358 Cherrytree 2491
15439 15439 13641 13641 Cherrytree 2491
16563 16563 14627 14627 Cherrytree 2491
16758 16758 14797 14797 Cherrytree 2491
16913 16913 14937 14937 Cherrytree 2491
17277 17277 15268 15268 Cherrytree 2491
18067 18067 15991 15991 Cherrytree 2491
19236 19236 17088 17088 Cherrytree 2491
21443 21443 19120 19120 Cherrytree 2491
21482 21482 19152 19152 Cherrytree 2491
22313 22313 19908 19908 Cherrytree 2491

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