home / pf

albums_labels

4 rows where label_id = 3306

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15778 15778 13928 13928 Comedy Central 3306
16459 16459 14533 14533 Comedy Central 3306
17812 17812 15748 15748 Comedy Central 3306
19765 19765 17609 17609 Comedy Central 3306

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