albums_labels

6 rows where label_id = 1408

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4074 4074 3568 3568 Bread Winners’ Association 1408
5494 5494 4782 4782 Bread Winners’ Association 1408
7007 7007 6102 6102 Bread Winners’ Association 1408
9025 9025 7884 7884 Bread Winners’ Association 1408
9526 9526 8329 8329 Bread Winners’ Association 1408
11023 11023 9654 9654 Bread Winners’ Association 1408

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