albums_labels

5 rows where label_id = 280

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
436 436 372 372 Vertigo 280
5203 5203 4540 4540 Vertigo 280
13140 13140 11552 11552 Vertigo 280
21489 21489 19157 19157 Vertigo 280
23252 23252 20782 20782 Vertigo 280

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