albums_labels

8 rows where label_id = 1639

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5127 5127 4485 4485 Hospital Productions 1639
6743 6743 5873 5873 Hospital Productions 1639
8938 8938 7804 7804 Hospital Productions 1639
9977 9977 8725 8725 Hospital Productions 1639
10437 10437 9132 9132 Hospital Productions 1639
12435 12435 10906 10906 Hospital Productions 1639
12506 12506 10971 10971 Hospital Productions 1639
19233 19233 17085 17085 Hospital Productions 1639

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