albums_labels

19 rows where label_id = 3335

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15971 15971 14100 14100 Shout! Factory 3335
16953 16953 14976 14976 Shout! Factory 3335
16955 16955 14977 14977 Shout! Factory 3335
17563 17563 15519 15519 Shout! Factory 3335
18130 18130 16049 16049 Shout! Factory 3335
18303 18303 16211 16211 Shout! Factory 3335
18549 18549 16443 16443 Shout! Factory 3335
19549 19549 17398 17398 Shout! Factory 3335
19775 19775 17618 17618 Shout! Factory 3335
19892 19892 17729 17729 Shout! Factory 3335
20068 20068 17882 17882 Shout! Factory 3335
20533 20533 18293 18293 Shout! Factory 3335
22072 22072 19691 19691 Shout! Factory 3335
22076 22076 19694 19694 Shout! Factory 3335
22669 22669 20234 20234 Shout! Factory 3335
22915 22915 20460 20460 Shout! Factory 3335
23345 23345 20872 20872 Shout! Factory 3335
24849 24849 22285 22285 Shout! Factory 3335
25414 25414 22833 22833 Shout! Factory 3335

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