albums_labels

9 rows where label_id = 1444

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4249 4249 3716 3716 Casablanca 1444
8634 8634 7528 7528 Casablanca 1444
10324 10324 9034 9034 Casablanca 1444
13893 13893 12244 12244 Casablanca 1444
14416 14416 12733 12733 Casablanca 1444
14535 14535 12839 12839 Casablanca 1444
24425 24425 21886 21886 Casablanca 1444
26648 26648 24015 24015 Casablanca 1444
29528 29528 26623 26623 Casablanca 1444

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