albums_labels

5 rows where label_id = 4662

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
25501 25501 22915 22915 Wishing Tree 4662
25869 25869 23267 23267 Wishing Tree 4662
27094 27094 24425 24425 Wishing Tree 4662
27647 27647 24943 24943 Wishing Tree 4662
27977 27977 25248 25248 Wishing Tree 4662

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