albums_labels

4 rows where label_id = 2706

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11308 11308 9891 9891 Hot Charity 2706
12257 12257 10736 10736 Hot Charity 2706
13851 13851 12206 12206 Hot Charity 2706
14779 14779 13051 13051 Hot Charity 2706

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