albums_labels

9 rows where label_id = 2841

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12231 12231 10714 10714 No Pain in Pop 2841
12408 12408 10880 10880 No Pain in Pop 2841
13509 13509 11897 11897 No Pain in Pop 2841
13913 13913 12262 12262 No Pain in Pop 2841
15296 15296 13509 13509 No Pain in Pop 2841
15537 15537 13728 13728 No Pain in Pop 2841
15814 15814 13961 13961 No Pain in Pop 2841
16575 16575 14639 14639 No Pain in Pop 2841
17707 17707 15653 15653 No Pain in Pop 2841

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