albums_labels

4 rows where label_id = 1850

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6231 6231 5425 5425 The Artist 1850
10141 10141 8874 8874 The Artist 1850
11053 11053 9675 9675 The Artist 1850
11385 11385 9958 9958 The Artist 1850

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