albums_labels

5 rows where label_id = 910

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2172 2172 1890 1890 Mac’s Record Label 910
4649 4649 4058 4058 Mac’s Record Label 910
29202 29202 26341 26341 Mac’s Record Label 910
29566 29566 26655 26655 Mac’s Record Label 910
30054 30054 27079 27079 Mac’s Record Label 910

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