albums_labels

13 rows where label_id = 2520

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10025 10025 8769 8769 Family Vineyard 2520
10505 10505 9192 9192 Family Vineyard 2520
16133 16133 14245 14245 Family Vineyard 2520
18997 18997 16850 16850 Family Vineyard 2520
20968 20968 18683 18683 Family Vineyard 2520
21706 21706 19356 19356 Family Vineyard 2520
25055 25055 22491 22491 Family Vineyard 2520
25925 25925 23322 23322 Family Vineyard 2520
26151 26151 23536 23536 Family Vineyard 2520
26472 26472 23842 23842 Family Vineyard 2520
27090 27090 24421 24421 Family Vineyard 2520
27485 27485 24789 24789 Family Vineyard 2520
27634 27634 24930 24930 Family Vineyard 2520

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