albums_labels

14 rows where label_id = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
43 43 38 38 Black Truffle 36
420 420 358 358 Black Truffle 36
696 696 586 586 Black Truffle 36
727 727 614 614 Black Truffle 36
1164 1164 1003 1003 Black Truffle 36
1504 1504 1304 1304 Black Truffle 36
1650 1650 1434 1434 Black Truffle 36
1682 1682 1464 1464 Black Truffle 36
2845 2845 2481 2481 Black Truffle 36
3731 3731 3253 3253 Black Truffle 36
4084 4084 3577 3577 Black Truffle 36
13099 13099 11513 11513 Black Truffle 36
14815 14815 13085 13085 Black Truffle 36
16980 16980 15001 15001 Black Truffle 36

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