albums_labels

11 rows where label_id = 3175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14742 14742 13021 13021 Sonic Unyon 3175
21000 21000 18714 18714 Sonic Unyon 3175
21816 21816 19453 19453 Sonic Unyon 3175
22056 22056 19676 19676 Sonic Unyon 3175
23043 23043 20580 20580 Sonic Unyon 3175
23782 23782 21278 21278 Sonic Unyon 3175
24033 24033 21520 21520 Sonic Unyon 3175
25146 25146 22574 22574 Sonic Unyon 3175
25334 25334 22757 22757 Sonic Unyon 3175
26235 26235 23616 23616 Sonic Unyon 3175
26700 26700 24064 24064 Sonic Unyon 3175

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