home / pf

albums_labels

8 rows where label_id = 2561

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10306 10306 9019 9019 Duckdown 2561
15699 15699 13858 13858 Duckdown 2561
16203 16203 14306 14306 Duckdown 2561
17619 17619 15567 15567 Duckdown 2561
18100 18100 16022 16022 Duckdown 2561
19817 19817 17658 17658 Duckdown 2561
19940 19940 17771 17771 Duckdown 2561
23780 23780 21276 21276 Duckdown 2561

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