albums_labels

8 rows where label_id = 381

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
627 627 527 527 Brushfire 381
14132 14132 12459 12459 Brushfire 381
15675 15675 13838 13838 Brushfire 381
17648 17648 15595 15595 Brushfire 381
19159 19159 17012 17012 Brushfire 381
20322 20322 18098 18098 Brushfire 381
20916 20916 18635 18635 Brushfire 381
21660 21660 19313 19313 Brushfire 381

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