albums_labels

5 rows where label_id = 2015

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7047 7047 6135 6135 Concord Music Group 2015
7254 7254 6310 6310 Concord Music Group 2015
8101 8101 7055 7055 Concord Music Group 2015
8602 8602 7503 7503 Concord Music Group 2015
8604 8604 7504 7504 Concord Music Group 2015

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