albums_labels

11 rows where label_id = 4051

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20874 20874 18596 18596 Better Looking 4051
21315 21315 19002 19002 Better Looking 4051
21957 21957 19583 19583 Better Looking 4051
24050 24050 21536 21536 Better Looking 4051
26278 26278 23656 23656 Better Looking 4051
26799 26799 24158 24158 Better Looking 4051
27103 27103 24434 24434 Better Looking 4051
27288 27288 24603 24603 Better Looking 4051
27763 27763 25048 25048 Better Looking 4051
27804 27804 25088 25088 Better Looking 4051
27924 27924 25197 25197 Better Looking 4051

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