albums_labels

14 rows where label_id = 2914

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12659 12659 11113 11113 Orange Twin 2914
16857 16857 14889 14889 Orange Twin 2914
19298 19298 17150 17150 Orange Twin 2914
20494 20494 18257 18257 Orange Twin 2914
21583 21583 19243 19243 Orange Twin 2914
21852 21852 19487 19487 Orange Twin 2914
24596 24596 22045 22045 Orange Twin 2914
25296 25296 22719 22719 Orange Twin 2914
26795 26795 24154 24154 Orange Twin 2914
27033 27033 24373 24373 Orange Twin 2914
27347 27347 24659 24659 Orange Twin 2914
27435 27435 24743 24743 Orange Twin 2914
28226 28226 25471 25471 Orange Twin 2914
28342 28342 25580 25580 Orange Twin 2914

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