home / pf

albums_labels

11 rows where label_id = 1864

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6299 6299 5484 5484 Columbia Legacy 1864
6834 6834 5959 5959 Columbia Legacy 1864
8167 8167 7116 7116 Columbia Legacy 1864
8504 8504 7414 7414 Columbia Legacy 1864
13410 13410 11803 11803 Columbia Legacy 1864
14767 14767 13041 13041 Columbia Legacy 1864
19440 19440 17291 17291 Columbia Legacy 1864
20611 20611 18365 18365 Columbia Legacy 1864
20620 20620 18371 18371 Columbia Legacy 1864
22049 22049 19669 19669 Columbia Legacy 1864
26035 26035 23425 23425 Columbia Legacy 1864

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