albums_labels

11 rows where label_id = 1565

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4826 4826 4216 4216 Ropeadope 1565
6894 6894 6008 6008 Ropeadope 1565
6895 6895 6009 6009 Ropeadope 1565
6896 6896 6010 6010 Ropeadope 1565
7310 7310 6358 6358 Ropeadope 1565
9250 9250 8091 8091 Ropeadope 1565
9932 9932 8687 8687 Ropeadope 1565
25071 25071 22506 22506 Ropeadope 1565
25376 25376 22799 22799 Ropeadope 1565
27231 27231 24550 24550 Ropeadope 1565
27989 27989 25258 25258 Ropeadope 1565

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