albums_labels

9 rows where label_id = 1306

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3633 3633 3169 3169 Vanguard 1306
7946 7946 6915 6915 Vanguard 1306
17045 17045 15061 15061 Vanguard 1306
17059 17059 15075 15075 Vanguard 1306
17736 17736 15678 15678 Vanguard 1306
19803 19803 17645 17645 Vanguard 1306
23106 23106 20639 20639 Vanguard 1306
24865 24865 22301 22301 Vanguard 1306
26954 26954 24300 24300 Vanguard 1306

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