albums_labels

6 rows where label_id = 273

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
417 417 355 355 The Leaf Label 273
1095 1095 940 940 The Leaf Label 273
2566 2566 2235 2235 The Leaf Label 273
3707 3707 3230 3230 The Leaf Label 273
5622 5622 4892 4892 The Leaf Label 273
8803 8803 7683 7683 The Leaf Label 273

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