albums_labels

5 rows where label_id = 2874

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12403 12403 10875 10875 Empty Cellar 2874
12943 12943 11370 11370 Empty Cellar 2874
15568 15568 13753 13753 Empty Cellar 2874
16152 16152 14260 14260 Empty Cellar 2874
17604 17604 15553 15553 Empty Cellar 2874

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