albums_labels

10 rows where label_id = 945

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2300 2300 2002 2002 Fueled by Ramen 945
6195 6195 5392 5392 Fueled by Ramen 945
6499 6499 5653 5653 Fueled by Ramen 945
6885 6885 6000 6000 Fueled by Ramen 945
7569 7569 6589 6589 Fueled by Ramen 945
10359 10359 9064 9064 Fueled by Ramen 945
21746 21746 19394 19394 Fueled by Ramen 945
23350 23350 20876 20876 Fueled by Ramen 945
28214 28214 25461 25461 Fueled by Ramen 945
30193 30193 27209 27209 Fueled by Ramen 945

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