albums_labels

9 rows where label_id = 312

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
495 495 418 418 Sinderlyn 312
2766 2766 2410 2410 Sinderlyn 312
3701 3701 3226 3226 Sinderlyn 312
4953 4953 4328 4328 Sinderlyn 312
6939 6939 6041 6041 Sinderlyn 312
8008 8008 6971 6971 Sinderlyn 312
8082 8082 7037 7037 Sinderlyn 312
8566 8566 7469 7469 Sinderlyn 312
30449 30449 27436 27436 Sinderlyn 312

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