albums_labels

4 rows where label_id = 2539

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10147 10147 8877 8877 Endless Flight 2539
10581 10581 9262 9262 Endless Flight 2539
12232 12232 10715 10715 Endless Flight 2539
21455 21455 19128 19128 Endless Flight 2539

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