albums_labels

14 rows where label_id = 1561

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4814 4814 4205 4205 Virgin EMI 1561
5028 5028 4391 4391 Virgin EMI 1561
6113 6113 5319 5319 Virgin EMI 1561
6234 6234 5428 5428 Virgin EMI 1561
7246 7246 6305 6305 Virgin EMI 1561
7248 7248 6306 6306 Virgin EMI 1561
7250 7250 6307 6307 Virgin EMI 1561
7747 7747 6743 6743 Virgin EMI 1561
8947 8947 7812 7812 Virgin EMI 1561
9143 9143 7997 7997 Virgin EMI 1561
9986 9986 8733 8733 Virgin EMI 1561
10093 10093 8831 8831 Virgin EMI 1561
10717 10717 9380 9380 Virgin EMI 1561
12158 12158 10647 10647 Virgin EMI 1561

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