home / pf

albums_labels

4 rows where label_id = 4323

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22765 22765 20323 20323 Global Symphonic 4323
22766 22766 20324 20324 Global Symphonic 4323
23059 23059 20596 20596 Global Symphonic 4323
23897 23897 21389 21389 Global Symphonic 4323

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