albums_labels

15 rows where label_id = 3993

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20521 20521 18282 18282 Ace Fu 3993
21305 21305 18992 18992 Ace Fu 3993
22048 22048 19668 19668 Ace Fu 3993
22248 22248 19854 19854 Ace Fu 3993
22304 22304 19901 19901 Ace Fu 3993
22495 22495 20075 20075 Ace Fu 3993
22563 22563 20137 20137 Ace Fu 3993
23087 23087 20623 20623 Ace Fu 3993
23191 23191 20722 20722 Ace Fu 3993
24656 24656 22102 22102 Ace Fu 3993
24695 24695 22138 22138 Ace Fu 3993
25745 25745 23149 23149 Ace Fu 3993
27484 27484 24788 24788 Ace Fu 3993
28051 28051 25315 25315 Ace Fu 3993
28946 28946 26125 26125 Ace Fu 3993

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