albums_labels

4 rows where label_id = 1983

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6828 6828 5954 5954 30th Century 1983
7869 7869 6848 6848 30th Century 1983
7887 7887 6865 6865 30th Century 1983
9276 9276 8110 8110 30th Century 1983

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