albums_labels

4 rows where label_id = 1413

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4105 4105 3596 3596 Tender Loving Empire 1413
4981 4981 4351 4351 Tender Loving Empire 1413
10028 10028 8771 8771 Tender Loving Empire 1413
29543 29543 26635 26635 Tender Loving Empire 1413

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