albums_labels

4 rows where label_id = 1785

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5887 5887 5131 5131 Third Worlds 1785
9260 9260 8097 8097 Third Worlds 1785
11763 11763 10296 10296 Third Worlds 1785
15786 15786 13935 13935 Third Worlds 1785

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