albums_labels

18 rows where label_id = 479

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
859 859 731 731 Prosthetic 479
2486 2486 2168 2168 Prosthetic 479
5272 5272 4599 4599 Prosthetic 479
5685 5685 4948 4948 Prosthetic 479
5807 5807 5059 5059 Prosthetic 479
9742 9742 8524 8524 Prosthetic 479
11590 11590 10142 10142 Prosthetic 479
11694 11694 10239 10239 Prosthetic 479
12234 12234 10717 10717 Prosthetic 479
12512 12512 10976 10976 Prosthetic 479
13169 13169 11577 11577 Prosthetic 479
13818 13818 12174 12174 Prosthetic 479
14548 14548 12850 12850 Prosthetic 479
14845 14845 13115 13115 Prosthetic 479
15392 15392 13601 13601 Prosthetic 479
18910 18910 16765 16765 Prosthetic 479
20391 20391 18160 18160 Prosthetic 479
29256 29256 26386 26386 Prosthetic 479

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