albums_labels

10 rows where label_id = 854

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1999 1999 1744 1744 Closed Sessions 854
4323 4323 3774 3774 Closed Sessions 854
4632 4632 4042 4042 Closed Sessions 854
7605 7605 6621 6621 Closed Sessions 854
8343 8343 7271 7271 Closed Sessions 854
8368 8368 7291 7291 Closed Sessions 854
8811 8811 7690 7690 Closed Sessions 854
9236 9236 8077 8077 Closed Sessions 854
29689 29689 26760 26760 Closed Sessions 854
29946 29946 26982 26982 Closed Sessions 854

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