albums_labels

7 rows where label_id = 1739

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5670 5670 4935 4935 Castle Face 1739
6758 6758 5887 5887 Castle Face 1739
7154 7154 6229 6229 Castle Face 1739
8271 8271 7209 7209 Castle Face 1739
8707 8707 7593 7593 Castle Face 1739
13371 13371 11766 11766 Castle Face 1739
18424 18424 16327 16327 Castle Face 1739

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