albums_labels

11 rows where label_id = 789

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1765 1765 1539 1539 Universal 789
2783 2783 2425 2425 Universal 789
4505 4505 3930 3930 Universal 789
4517 4517 3941 3941 Universal 789
4702 4702 4103 4103 Universal 789
6892 6892 6006 6006 Universal 789
7107 7107 6191 6191 Universal 789
29190 29190 26330 26330 Universal 789
29376 29376 26488 26488 Universal 789
29462 29462 26562 26562 Universal 789
29832 29832 26882 26882 Universal 789

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