albums_labels

5 rows where label_id = 2704

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11291 11291 9875 9875 Blackball 2704
13737 13737 12101 12101 Blackball 2704
17502 17502 15466 15466 Blackball 2704
27135 27135 24463 24463 Blackball 2704
28913 28913 26098 26098 Blackball 2704

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