albums_labels

5 rows where label_id = 1315

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3674 3674 3206 3206 Black Butter 1315
4483 4483 3914 3914 Black Butter 1315
5587 5587 4865 4865 Black Butter 1315
7551 7551 6573 6573 Black Butter 1315
29769 29769 26828 26828 Black Butter 1315

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