albums_labels

4 rows where label_id = 4151

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21517 21517 19183 19183 Last Visible Dog 4151
25700 25700 23105 23105 Last Visible Dog 4151
26015 26015 23405 23405 Last Visible Dog 4151
26067 26067 23457 23457 Last Visible Dog 4151

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