albums_labels

7 rows where label_id = 1053

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2634 2634 2297 2297 Demon 1053
14339 14339 12660 12660 Demon 1053
15809 15809 13956 13956 Demon 1053
15810 15810 13957 13957 Demon 1053
15811 15811 13958 13958 Demon 1053
15885 15885 14024 14024 Demon 1053
15886 15886 14025 14025 Demon 1053

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