albums_labels

5 rows where label_id = 4314

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22691 22691 20252 20252 Family 4314
23814 23814 21310 21310 Family 4314
23869 23869 21363 21363 Family 4314
24336 24336 21802 21802 Family 4314
24348 24348 21814 21814 Family 4314

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