albums_labels

18 rows where label_id = 413

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
700 700 589 589 Harvest 413
3026 3026 2648 2648 Harvest 413
4388 4388 3830 3830 Harvest 413
8450 8450 7363 7363 Harvest 413
9102 9102 7959 7959 Harvest 413
10092 10092 8831 8831 Harvest 413
10556 10556 9239 9239 Harvest 413
10649 10649 9319 9319 Harvest 413
10705 10705 9371 9371 Harvest 413
11153 11153 9760 9760 Harvest 413
11174 11174 9779 9779 Harvest 413
11458 11458 10022 10022 Harvest 413
11650 11650 10197 10197 Harvest 413
11762 11762 10296 10296 Harvest 413
12052 12052 10551 10551 Harvest 413
22759 22759 20317 20317 Harvest 413
22760 22760 20318 20318 Harvest 413
22761 22761 20319 20319 Harvest 413

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