albums_labels

5 rows where label_id = 1157

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3043 3043 2663 2663 Gilead Media 1157
7244 7244 6303 6303 Gilead Media 1157
10106 10106 8843 8843 Gilead Media 1157
10375 10375 9079 9079 Gilead Media 1157
12159 12159 10648 10648 Gilead Media 1157

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