albums_labels

9 rows where label_id = 3663

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18529 18529 16425 16425 Carrot Top 3663
18742 18742 16623 16623 Carrot Top 3663
20038 20038 17858 17858 Carrot Top 3663
22535 22535 20110 20110 Carrot Top 3663
24392 24392 21854 21854 Carrot Top 3663
25926 25926 23323 23323 Carrot Top 3663
28043 28043 25307 25307 Carrot Top 3663
28528 28528 25751 25751 Carrot Top 3663
28942 28942 26121 26121 Carrot Top 3663

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