albums_labels

9 rows where label_id = 892

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2125 2125 1849 1849 K Records 892
3818 3818 3335 3335 K Records 892
3819 3819 3336 3336 K Records 892
3820 3820 3337 3337 K Records 892
3821 3821 3338 3338 K Records 892
3823 3823 3339 3339 K Records 892
3825 3825 3340 3340 K Records 892
5423 5423 4724 4724 K Records 892
12757 12757 11202 11202 K Records 892

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