albums_labels

7 rows where label_id = 1472

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4381 4381 3824 3824 Duophonic 1472
4382 4382 3825 3825 Duophonic 1472
4384 4384 3827 3827 Duophonic 1472
6316 6316 5500 5500 Duophonic 1472
7293 7293 6345 6345 Duophonic 1472
9455 9455 8268 8268 Duophonic 1472
16638 16638 14689 14689 Duophonic 1472

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