albums_labels

16 rows where label_id = 1949

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6669 6669 5805 5805 Knitting Factory 1949
11346 11346 9925 9925 Knitting Factory 1949
11347 11347 9926 9926 Knitting Factory 1949
11348 11348 9927 9927 Knitting Factory 1949
11349 11349 9928 9928 Knitting Factory 1949
11350 11350 9929 9929 Knitting Factory 1949
11351 11351 9930 9930 Knitting Factory 1949
11352 11352 9931 9931 Knitting Factory 1949
11353 11353 9932 9932 Knitting Factory 1949
12648 12648 11103 11103 Knitting Factory 1949
14633 14633 12928 12928 Knitting Factory 1949
15652 15652 13820 13820 Knitting Factory 1949
17128 17128 15138 15138 Knitting Factory 1949
17846 17846 15780 15780 Knitting Factory 1949
27910 27910 25184 25184 Knitting Factory 1949
29115 29115 26265 26265 Knitting Factory 1949

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