albums_labels

5 rows where label_id = 3646

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18383 18383 16288 16288 Wrasse 3646
21828 21828 19465 19465 Wrasse 3646
23665 23665 21168 21168 Wrasse 3646
23894 23894 21386 21386 Wrasse 3646
24098 24098 21579 21579 Wrasse 3646

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