home / pf

albums_labels

4 rows where label_id = 957

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2336 2336 2032 2032 T4T LUV NRG 957
4160 4160 3642 3642 T4T LUV NRG 957
4453 4453 3886 3886 T4T LUV NRG 957
29961 29961 26994 26994 T4T LUV NRG 957

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