albums_labels

13 rows where label_id = 401

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
672 672 565 565 UMG 401
3034 3034 2655 2655 UMG 401
3887 3887 3397 3397 UMG 401
3888 3888 3398 3398 UMG 401
3889 3889 3399 3399 UMG 401
4804 4804 4196 4196 UMG 401
4866 4866 4253 4253 UMG 401
5332 5332 4644 4644 UMG 401
6648 6648 5785 5785 UMG 401
7375 7375 6413 6413 UMG 401
8347 8347 7274 7274 UMG 401
8912 8912 7782 7782 UMG 401
29338 29338 26458 26458 UMG 401

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