albums_labels

21 rows where label_id = 84

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
97 97 87 87 Room40 84
570 570 478 478 Room40 84
749 749 634 634 Room40 84
2779 2779 2422 2422 Room40 84
2912 2912 2541 2541 Room40 84
4528 4528 3952 3952 Room40 84
5180 5180 4526 4526 Room40 84
7323 7323 6368 6368 Room40 84
8890 8890 7761 7761 Room40 84
9776 9776 8556 8556 Room40 84
10204 10204 8929 8929 Room40 84
11581 11581 10133 10133 Room40 84
16539 16539 14607 14607 Room40 84
16759 16759 14798 14798 Room40 84
19009 19009 16862 16862 Room40 84
23307 23307 20834 20834 Room40 84
24655 24655 22101 22101 Room40 84
25147 25147 22575 22575 Room40 84
25421 25421 22840 22840 Room40 84
25449 25449 22866 22866 Room40 84
26251 26251 23631 23631 Room40 84

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