home / pf

albums_labels

4 rows where label_id = 359

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
592 592 496 496 Raven Marching Band 359
15174 15174 13404 13404 Raven Marching Band 359
17821 17821 15756 15756 Raven Marching Band 359
22359 22359 19952 19952 Raven Marching Band 359

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