albums_labels

7 rows where label_id = 1465

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4357 4357 3805 3805 Roc Nation 1465
4411 4411 3849 3849 Roc Nation 1465
5006 5006 4373 4373 Roc Nation 1465
5921 5921 5163 5163 Roc Nation 1465
6769 6769 5898 5898 Roc Nation 1465
6813 6813 5939 5939 Roc Nation 1465
7265 7265 6318 6318 Roc Nation 1465

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