albums_labels

7 rows where label_id = 1926

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6581 6581 5726 5726 Island Def Jam 1926
13794 13794 12152 12152 Island Def Jam 1926
14367 14367 12687 12687 Island Def Jam 1926
15080 15080 13316 13316 Island Def Jam 1926
16350 16350 14438 14438 Island Def Jam 1926
17422 17422 15391 15391 Island Def Jam 1926
30351 30351 27349 27349 Island Def Jam 1926

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