home / pf

albums_labels

5 rows where label_id = 3753

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19141 19141 16994 16994 Eighteenth Street Lounge 3753
24433 24433 21894 21894 Eighteenth Street Lounge 3753
27169 27169 24495 24495 Eighteenth Street Lounge 3753
28645 28645 25856 25856 Eighteenth Street Lounge 3753
29080 29080 26239 26239 Eighteenth Street Lounge 3753

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