albums_labels

4 rows where label_id = 3071

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13973 13973 12316 12316 Richter Scale 3071
16361 16361 14448 14448 Richter Scale 3071
19011 19011 16864 16864 Richter Scale 3071
19344 19344 17196 17196 Richter Scale 3071

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