albums_labels

9 rows where label_id = 3846

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19660 19660 17507 17507 Wizard 3846
23139 23139 20670 20670 Wizard 3846
23140 23140 20671 20671 Wizard 3846
23141 23141 20672 20672 Wizard 3846
23142 23142 20673 20673 Wizard 3846
23256 23256 20786 20786 Wizard 3846
23257 23257 20787 20787 Wizard 3846
23258 23258 20788 20788 Wizard 3846
23259 23259 20789 20789 Wizard 3846

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