albums_labels

7 rows where label_id = 2080

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7395 7395 6431 6431 SideOneDummy 2080
8248 8248 7186 7186 SideOneDummy 2080
9030 9030 7889 7889 SideOneDummy 2080
17211 17211 15210 15210 SideOneDummy 2080
19254 19254 17106 17106 SideOneDummy 2080
21111 21111 18816 18816 SideOneDummy 2080
23678 23678 21181 21181 SideOneDummy 2080

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