albums_labels

4 rows where album_id = 4756

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5461 5461 4756 4756 Quality Control 120
5462 5462 4756 4756 Young Stoner Life 598
5463 5463 4756 4756 Capitol 112
5464 5464 4756 4756 Motown 121

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