home / pf

albums_labels

13 rows where label_id = 1599

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4961 4961 4335 4335 DGC 1599
5873 5873 5118 5118 DGC 1599
7912 7912 6886 6886 DGC 1599
15191 15191 13421 13421 DGC 1599
15579 15579 13760 13760 DGC 1599
17009 17009 15029 15029 DGC 1599
17990 17990 15917 15917 DGC 1599
18137 18137 16056 16056 DGC 1599
19906 19906 17741 17741 DGC 1599
26540 26540 23909 23909 DGC 1599
27223 27223 24544 24544 DGC 1599
28775 28775 25974 25974 DGC 1599
28826 28826 26020 26020 DGC 1599

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