albums_labels

18 rows where label_id = 78

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
90 90 81 81 Weird World 78
1337 1337 1151 1151 Weird World 78
2705 2705 2363 2363 Weird World 78
4017 4017 3515 3515 Weird World 78
7456 7456 6486 6486 Weird World 78
8331 8331 7262 7262 Weird World 78
8528 8528 7435 7435 Weird World 78
8594 8594 7496 7496 Weird World 78
10369 10369 9073 9073 Weird World 78
10931 10931 9567 9567 Weird World 78
11165 11165 9771 9771 Weird World 78
11197 11197 9799 9799 Weird World 78
11333 11333 9913 9913 Weird World 78
11727 11727 10264 10264 Weird World 78
12969 12969 11393 11393 Weird World 78
14451 14451 12765 12765 Weird World 78
15032 15032 13273 13273 Weird World 78
15751 15751 13906 13906 Weird World 78

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