albums_labels

4 rows where label_id = 1955

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6684 6684 5819 5819 Halocline Trance 1955
7631 7631 6646 6646 Halocline Trance 1955
8030 8030 6990 6990 Halocline Trance 1955
9355 9355 8179 8179 Halocline Trance 1955

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