albums_labels

6 rows where label_id = 4080

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21060 21060 18767 18767 Trojan 4080
21591 21591 19251 19251 Trojan 4080
21699 21699 19349 19349 Trojan 4080
23251 23251 20781 20781 Trojan 4080
23935 23935 21425 21425 Trojan 4080
26940 26940 24288 24288 Trojan 4080

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