home / pf

albums_labels

6 rows where label_id = 907

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2155 2155 1874 1874 6131 907
3232 3232 2827 2827 6131 907
3759 3759 3280 3280 6131 907
7504 7504 6530 6530 6131 907
9814 9814 8585 8585 6131 907
11305 11305 9888 9888 6131 907

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