albums_labels

9 rows where label_id = 154

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
190 190 166 166 You’ve Changed 154
819 819 692 692 You’ve Changed 154
1328 1328 1142 1142 You’ve Changed 154
2019 2019 1760 1760 You’ve Changed 154
2216 2216 1929 1929 You’ve Changed 154
2786 2786 2428 2428 You’ve Changed 154
6376 6376 5553 5553 You’ve Changed 154
7078 7078 6164 6164 You’ve Changed 154
11278 11278 9866 9866 You’ve Changed 154

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