albums_labels

4 rows where album_id = 8429

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9635 9635 8429 8429 Empire 32
9636 9636 8429 8429 OBE 1340
9637 9637 8429 8429 Steel Wool 2459
9638 9638 8429 8429 Art Club 2460

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