albums_labels

8 rows where label_id = 2480

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9765 9765 8546 8546 Other Music 2480
11303 11303 9886 9886 Other Music 2480
11429 11429 9998 9998 Other Music 2480
11467 11467 10030 10030 Other Music 2480
12529 12529 10992 10992 Other Music 2480
12605 12605 11061 11061 Other Music 2480
13684 13684 12053 12053 Other Music 2480
14208 14208 12533 12533 Other Music 2480

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