albums_labels

7 rows where label_id = 3016

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13528 13528 11912 11912 Slender Means Society 3016
19796 19796 17638 17638 Slender Means Society 3016
20075 20075 17888 17888 Slender Means Society 3016
21448 21448 19124 19124 Slender Means Society 3016
21558 21558 19223 19223 Slender Means Society 3016
21901 21901 19530 19530 Slender Means Society 3016
22532 22532 20108 20108 Slender Means Society 3016

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