albums_labels

5 rows where label_id = 1968

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6767 6767 5896 5896 Eskimo 1968
9913 9913 8668 8668 Eskimo 1968
18611 18611 16500 16500 Eskimo 1968
23125 23125 20656 20656 Eskimo 1968
23928 23928 21418 21418 Eskimo 1968

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