albums_labels

9 rows where label_id = 1013

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2485 2485 2167 2167 Late Night Tales 1013
4816 4816 4207 4207 Late Night Tales 1013
10785 10785 9439 9439 Late Night Tales 1013
11575 11575 10127 10127 Late Night Tales 1013
13026 13026 11442 11442 Late Night Tales 1013
14146 14146 12473 12473 Late Night Tales 1013
14363 14363 12684 12684 Late Night Tales 1013
14791 14791 13062 13062 Late Night Tales 1013
15425 15425 13628 13628 Late Night Tales 1013

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