albums_labels

8 rows where label_id = 1585

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4892 4892 4275 4275 Vapor 1585
16351 16351 14439 14439 Vapor 1585
18046 18046 15970 15970 Vapor 1585
19320 19320 17172 17172 Vapor 1585
19714 19714 17560 17560 Vapor 1585
21101 21101 18807 18807 Vapor 1585
24557 24557 22009 22009 Vapor 1585
27939 27939 25212 25212 Vapor 1585

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