home / pf

albums_labels

8 rows where label_id = 3783

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
19329 19329 17181 17181 Huume 3783
20672 20672 18419 18419 Huume 3783
21371 21371 19053 19053 Huume 3783
22082 22082 19700 19700 Huume 3783
22654 22654 20219 20219 Huume 3783
23150 23150 20681 20681 Huume 3783
23151 23151 20682 20682 Huume 3783
25270 25270 22695 22695 Huume 3783

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