albums_labels

6 rows where label_id = 3867

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19754 19754 17599 17599 World Music Network 3867
21109 21109 18814 18814 World Music Network 3867
22232 22232 19839 19839 World Music Network 3867
22233 22233 19840 19840 World Music Network 3867
23487 23487 21001 21001 World Music Network 3867
25668 25668 23074 23074 World Music Network 3867

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