home / pf

albums_labels

6 rows where label_id = 4220

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21908 21908 19536 19536 Eclipse 4220
23741 23741 21238 21238 Eclipse 4220
24123 24123 21601 21601 Eclipse 4220
24629 24629 22075 22075 Eclipse 4220
24791 24791 22228 22228 Eclipse 4220
26139 26139 23524 23524 Eclipse 4220

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