home / pf

albums_labels

11 rows where label_id = 797

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1809 1809 1583 1583 Entertainment One 797
6897 6897 6011 6011 Entertainment One 797
8057 8057 7014 7014 Entertainment One 797
8522 8522 7430 7430 Entertainment One 797
8796 8796 7677 7677 Entertainment One 797
8872 8872 7743 7743 Entertainment One 797
9900 9900 8659 8659 Entertainment One 797
9925 9925 8680 8680 Entertainment One 797
10082 10082 8821 8821 Entertainment One 797
11758 11758 10292 10292 Entertainment One 797
13075 13075 11489 11489 Entertainment One 797

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)
);
Powered by Datasette · Queries took 67.815ms