home / pf

albums_labels

5 rows where label_id = 4483

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24159 24159 21634 21634 None 4483
25283 25283 22706 22706 None 4483
25470 25470 22886 22886 None 4483
26704 26704 24067 24067 None 4483
28823 28823 26018 26018 None 4483

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