albums_labels

12 rows where label_id = 434

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
746 746 631 631 dBpm 434
2631 2631 2294 2294 dBpm 434
4051 4051 3548 3548 dBpm 434
4753 4753 4148 4148 dBpm 434
5230 5230 4564 4564 dBpm 434
7396 7396 6432 6432 dBpm 434
8595 8595 7497 7497 dBpm 434
10254 10254 8971 8971 dBpm 434
11420 11420 9991 9991 dBpm 434
15022 15022 13265 13265 dBpm 434
15467 15467 13666 13666 dBpm 434
29985 29985 27016 27016 dBpm 434

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