albums_labels

7 rows where label_id = 393

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
651 651 547 547 Fontana 393
15845 15845 13989 13989 Fontana 393
19901 19901 17737 17737 Fontana 393
19977 19977 17805 17805 Fontana 393
21154 21154 18856 18856 Fontana 393
21155 21155 18857 18857 Fontana 393
21156 21156 18858 18858 Fontana 393

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