albums_labels

4 rows where label_id = 4551

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24762 24762 22201 22201 Grand Royal 4551
28970 28970 26147 26147 Grand Royal 4551
28993 28993 26167 26167 Grand Royal 4551
28996 28996 26170 26170 Grand Royal 4551

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