albums_labels

8 rows where label_id = 914

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2191 2191 1907 1907 Technicolour 914
3137 3137 2742 2742 Technicolour 914
6237 6237 5431 5431 Technicolour 914
7433 7433 6467 6467 Technicolour 914
8214 8214 7156 7156 Technicolour 914
8751 8751 7634 7634 Technicolour 914
8786 8786 7667 7667 Technicolour 914
10216 10216 8939 8939 Technicolour 914

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