albums_labels

5 rows where label_id = 3746

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19111 19111 16964 16964 SideCho 3746
20561 20561 18320 18320 SideCho 3746
21295 21295 18982 18982 SideCho 3746
22953 22953 20495 20495 SideCho 3746
24506 24506 21963 21963 SideCho 3746

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