albums_labels

20 rows where label_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
47 47 42 42 Hausu Mountain 40
385 385 328 328 Hausu Mountain 40
561 561 470 470 Hausu Mountain 40
737 737 624 624 Hausu Mountain 40
855 855 726 726 Hausu Mountain 40
1454 1454 1261 1261 Hausu Mountain 40
1659 1659 1443 1443 Hausu Mountain 40
1916 1916 1673 1673 Hausu Mountain 40
2462 2462 2146 2146 Hausu Mountain 40
2550 2550 2221 2221 Hausu Mountain 40
3268 3268 2859 2859 Hausu Mountain 40
3527 3527 3080 3080 Hausu Mountain 40
3704 3704 3228 3228 Hausu Mountain 40
4004 4004 3502 3502 Hausu Mountain 40
4605 4605 4019 4019 Hausu Mountain 40
4859 4859 4246 4246 Hausu Mountain 40
5655 5655 4920 4920 Hausu Mountain 40
7964 7964 6932 6932 Hausu Mountain 40
9845 9845 8612 8612 Hausu Mountain 40
10806 10806 9457 9457 Hausu Mountain 40

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