albums_labels

8 rows where label_id = 1291

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3574 3574 3116 3116 Smithsonian Folkways 1291
4096 4096 3588 3588 Smithsonian Folkways 1291
6218 6218 5413 5413 Smithsonian Folkways 1291
10826 10826 9475 9475 Smithsonian Folkways 1291
14356 14356 12677 12677 Smithsonian Folkways 1291
29250 29250 26380 26380 Smithsonian Folkways 1291
29860 29860 26906 26906 Smithsonian Folkways 1291
30126 30126 27146 27146 Smithsonian Folkways 1291

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