albums_labels

7 rows where label_id = 2630

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10786 10786 9440 9440 Hessle Audio 2630
13912 13912 12261 12261 Hessle Audio 2630
15755 15755 13909 13909 Hessle Audio 2630
17159 17159 15167 15167 Hessle Audio 2630
29266 29266 26394 26394 Hessle Audio 2630
30013 30013 27041 27041 Hessle Audio 2630
30072 30072 27095 27095 Hessle Audio 2630

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