home / pf

albums_labels

5 rows where label_id = 4856

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
26842 26842 24197 24197 Squealer 4856
26953 26953 24299 24299 Squealer 4856
27107 27107 24437 24437 Squealer 4856
27385 27385 24696 24696 Squealer 4856
28232 28232 25476 25476 Squealer 4856

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.098ms