albums_labels

8 rows where label_id = 2894

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12502 12502 10967 10967 Digitalis 2894
13461 13461 11851 11851 Digitalis 2894
14038 14038 12372 12372 Digitalis 2894
15556 15556 13743 13743 Digitalis 2894
15666 15666 13830 13830 Digitalis 2894
16476 16476 14547 14547 Digitalis 2894
16685 16685 14729 14729 Digitalis 2894
23111 23111 20643 20643 Digitalis 2894

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