albums_labels

11 rows where label_id = 2082

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7408 7408 6443 6443 New Amsterdam 2082
8166 8166 7115 7115 New Amsterdam 2082
8243 8243 7182 7182 New Amsterdam 2082
8494 8494 7404 7404 New Amsterdam 2082
8653 8653 7544 7544 New Amsterdam 2082
9174 9174 8024 8024 New Amsterdam 2082
9480 9480 8291 8291 New Amsterdam 2082
9821 9821 8590 8590 New Amsterdam 2082
9976 9976 8724 8724 New Amsterdam 2082
16513 16513 14583 14583 New Amsterdam 2082
16572 16572 14636 14636 New Amsterdam 2082

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