albums_labels

6 rows where label_id = 1799

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5936 5936 5176 5176 Chapter Music 1799
10347 10347 9053 9053 Chapter Music 1799
10803 10803 9455 9455 Chapter Music 1799
18111 18111 16032 16032 Chapter Music 1799
21483 21483 19153 19153 Chapter Music 1799
21803 21803 19443 19443 Chapter Music 1799

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