albums_labels

10 rows where label_id = 3428

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16732 16732 14772 14772 Majordomo 3428
16733 16733 14773 14773 Majordomo 3428
16954 16954 14976 14976 Majordomo 3428
16956 16956 14977 14977 Majordomo 3428
17307 17307 15297 15297 Majordomo 3428
17308 17308 15298 15298 Majordomo 3428
17610 17610 15558 15558 Majordomo 3428
19070 19070 16923 16923 Majordomo 3428
19507 19507 17357 17357 Majordomo 3428
20987 20987 18701 18701 Majordomo 3428

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