home / pf

albums_labels

9 rows where label_id = 831

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1926 1926 1683 1683 United Souls 831
1928 1928 1684 1684 United Souls 831
1929 1929 1685 1685 United Souls 831
1930 1930 1686 1686 United Souls 831
1931 1931 1687 1687 United Souls 831
1932 1932 1688 1688 United Souls 831
1933 1933 1689 1689 United Souls 831
1934 1934 1690 1690 United Souls 831
1935 1935 1691 1691 United Souls 831

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