albums_labels

7 rows where label_id = 208

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
292 292 253 253 Ramp Local 208
475 475 404 404 Ramp Local 208
476 476 405 405 Ramp Local 208
2461 2461 2145 2145 Ramp Local 208
7975 7975 6942 6942 Ramp Local 208
29370 29370 26484 26484 Ramp Local 208
30055 30055 27080 27080 Ramp Local 208

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