albums_labels

18 rows where label_id = 307

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
488 488 413 413 BBE Music 307
722 722 609 609 BBE Music 307
2004 2004 1748 1748 BBE Music 307
2224 2224 1936 1936 BBE Music 307
5285 5285 4607 4607 BBE Music 307
5481 5481 4770 4770 BBE Music 307
11819 11819 10345 10345 BBE Music 307
18397 18397 16301 16301 BBE Music 307
19459 19459 17310 17310 BBE Music 307
22134 22134 19751 19751 BBE Music 307
22368 22368 19960 19960 BBE Music 307
22838 22838 20390 20390 BBE Music 307
23031 23031 20568 20568 BBE Music 307
23559 23559 21071 21071 BBE Music 307
24571 24571 22022 22022 BBE Music 307
24970 24970 22406 22406 BBE Music 307
26854 26854 24207 24207 BBE Music 307
29519 29519 26616 26616 BBE Music 307

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