albums_labels

9 rows where label_id = 2081

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7400 7400 6435 6435 NPG 2081
8623 8623 7520 7520 NPG 2081
9646 9646 8437 8437 NPG 2081
10075 10075 8815 8815 NPG 2081
18817 18817 16683 16683 NPG 2081
18818 18818 16684 16684 NPG 2081
18819 18819 16685 16685 NPG 2081
25440 25440 22857 22857 NPG 2081
29342 29342 26461 26461 NPG 2081

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