albums_labels

7 rows where label_id = 3406

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16566 16566 14630 14630 Sterns Africa 3406
17799 17799 15736 15736 Sterns Africa 3406
18963 18963 16816 16816 Sterns Africa 3406
20436 20436 18200 18200 Sterns Africa 3406
20437 20437 18201 18201 Sterns Africa 3406
20591 20591 18346 18346 Sterns Africa 3406
20811 20811 18540 18540 Sterns Africa 3406

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