home / pf

albums_labels

5 rows where label_id = 4482

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24158 24158 21634 21634 Bar 4482
25282 25282 22706 22706 Bar 4482
25469 25469 22886 22886 Bar 4482
26703 26703 24067 24067 Bar 4482
28822 28822 26018 26018 Bar 4482

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