home / pf

albums_labels

9 rows where label_id = 3881

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19807 19807 17649 17649 Unknown 3881
19836 19836 17677 17677 Unknown 3881
20020 20020 17842 17842 Unknown 3881
20711 20711 18453 18453 Unknown 3881
20785 20785 18516 18516 Unknown 3881
22004 22004 19628 19628 Unknown 3881
22347 22347 19942 19942 Unknown 3881
22425 22425 20012 20012 Unknown 3881
22525 22525 20102 20102 Unknown 3881

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 63.209ms