albums_labels

4 rows where label_id = 894

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2127 2127 1850 1850 Teichiku Entertainment 894
2129 2129 1851 1851 Teichiku Entertainment 894
2131 2131 1852 1852 Teichiku Entertainment 894
2133 2133 1853 1853 Teichiku Entertainment 894

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