albums_labels

3 rows where label_id = 1232

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3343 3343 2922 2922 South Coast Music Group 1232
4072 4072 3567 3567 South Coast Music Group 1232
4908 4908 4291 4291 South Coast Music Group 1232

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