albums_labels

14 rows where label_id = 3819

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19538 19538 17387 17387 Table of the Elements 3819
20037 20037 17857 17857 Table of the Elements 3819
20144 20144 17946 17946 Table of the Elements 3819
20264 20264 18045 18045 Table of the Elements 3819
21132 21132 18835 18835 Table of the Elements 3819
21722 21722 19372 19372 Table of the Elements 3819
21829 21829 19466 19466 Table of the Elements 3819
21956 21956 19582 19582 Table of the Elements 3819
22112 22112 19729 19729 Table of the Elements 3819
23319 23319 20846 20846 Table of the Elements 3819
23615 23615 21125 21125 Table of the Elements 3819
26530 26530 23899 23899 Table of the Elements 3819
28162 28162 25412 25412 Table of the Elements 3819
28772 28772 25971 25971 Table of the Elements 3819

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