albums_labels

3 rows where label_id = 1688

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5344 5344 4653 4653 Take Me to the Hospital 1688
10710 10710 9375 9375 Take Me to the Hospital 1688
19006 19006 16859 16859 Take Me to the Hospital 1688

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