home / pf

albums_labels

6 rows where label_id = 3376

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16322 16322 14415 14415 Rare Book Room 3376
16882 16882 14913 14913 Rare Book Room 3376
17976 17976 15904 15904 Rare Book Room 3376
19346 19346 17198 17198 Rare Book Room 3376
19468 19468 17319 17319 Rare Book Room 3376
20324 20324 18100 18100 Rare Book Room 3376

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