albums_labels

9 rows where label_id = 1598

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4959 4959 4333 4333 Canvasback 1598
7479 7479 6508 6508 Canvasback 1598
11815 11815 10342 10342 Canvasback 1598
14080 14080 12409 12409 Canvasback 1598
14813 14813 13083 13083 Canvasback 1598
16245 16245 14344 14344 Canvasback 1598
18759 18759 16636 16636 Canvasback 1598
19425 19425 17276 17276 Canvasback 1598
19553 19553 17401 17401 Canvasback 1598

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