home / pf

albums_labels

4 rows where label_id = 130

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
152 152 130 130 Wikset Enterprise 130
1511 1511 1309 1309 Wikset Enterprise 130
1981 1981 1730 1730 Wikset Enterprise 130
3904 3904 3412 3412 Wikset Enterprise 130

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