albums_labels

5 rows where label_id = 4498

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24285 24285 21756 21756 Cold Crush 4498
24451 24451 21912 21912 Cold Crush 4498
26191 26191 23573 23573 Cold Crush 4498
26254 26254 23634 23634 Cold Crush 4498
26792 26792 24151 24151 Cold Crush 4498

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