albums_labels

5 rows where label_id = 3701

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18865 18865 16723 16723 Ape House Ltd. 3701
18867 18867 16724 16724 Ape House Ltd. 3701
21849 21849 19484 19484 Ape House Ltd. 3701
24723 24723 22164 22164 Ape House Ltd. 3701
24724 24724 22165 22165 Ape House Ltd. 3701

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