home / pf

albums_labels

7 rows where label_id = 4404

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
23442 23442 20960 20960 Burning Heart 4404
23812 23812 21308 21308 Burning Heart 4404
25386 25386 22806 22806 Burning Heart 4404
27397 27397 24707 24707 Burning Heart 4404
27659 27659 24953 24953 Burning Heart 4404
27818 27818 25098 25098 Burning Heart 4404
28757 28757 25956 25956 Burning Heart 4404

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