home / pf

albums_labels

4 rows where label_id = 2660

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11003 11003 9636 9636 Emotional Response 2660
12546 12546 11007 11007 Emotional Response 2660
12974 12974 11398 11398 Emotional Response 2660
13751 13751 12114 12114 Emotional Response 2660

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.164ms