albums_labels

4 rows where label_id = 245

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
364 364 311 311 Late Music 245
1580 1580 1372 1372 Late Music 245
2778 2778 2421 2421 Late Music 245
30120 30120 27141 27141 Late Music 245

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