albums_labels

8 rows where label_id = 776

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1714 1714 1494 1494 Driftless 776
8422 8422 7336 7336 Driftless 776
9491 9491 8300 8300 Driftless 776
10252 10252 8969 8969 Driftless 776
10977 10977 9612 9612 Driftless 776
11211 11211 9807 9807 Driftless 776
11689 11689 10234 10234 Driftless 776
12456 12456 10927 10927 Driftless 776

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