albums_labels

3 rows where label_id = 3812

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19505 19505 17355 17355 Deaf Dumb and Blind 3812
20694 20694 18438 18438 Deaf Dumb and Blind 3812
21374 21374 19056 19056 Deaf Dumb and Blind 3812

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