albums_labels

6 rows where label_id = 1117

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2898 2898 2528 2528 Dualtone 1117
5013 5013 4379 4379 Dualtone 1117
5584 5584 4862 4862 Dualtone 1117
7454 7454 6484 6484 Dualtone 1117
11747 11747 10282 10282 Dualtone 1117
16990 16990 15010 15010 Dualtone 1117

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