albums_labels

11 rows where label_id = 379

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
625 625 525 525 Shelter Press 379
866 866 739 739 Shelter Press 379
3260 3260 2852 2852 Shelter Press 379
4423 4423 3860 3860 Shelter Press 379
5015 5015 4381 4381 Shelter Press 379
5312 5312 4626 4626 Shelter Press 379
5408 5408 4709 4709 Shelter Press 379
10757 10757 9412 9412 Shelter Press 379
11096 11096 9711 9711 Shelter Press 379
13029 13029 11445 11445 Shelter Press 379
30220 30220 27232 27232 Shelter Press 379

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