albums_labels

10 rows where label_id = 3902

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19946 19946 17777 17777 Chocolate Ind. 3902
23165 23165 20696 20696 Chocolate Ind. 3902
23406 23406 20928 20928 Chocolate Ind. 3902
25419 25419 22838 22838 Chocolate Ind. 3902
25800 25800 23204 23204 Chocolate Ind. 3902
25868 25868 23266 23266 Chocolate Ind. 3902
26175 26175 23559 23559 Chocolate Ind. 3902
26579 26579 23946 23946 Chocolate Ind. 3902
27248 27248 24565 24565 Chocolate Ind. 3902
27361 27361 24673 24673 Chocolate Ind. 3902

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